
#import dependencies
import numpy as np
import pandas as pd
import matplotlib.pyplot as plt
import seaborn as sb
import helpers
import matplotlib.dates as mdates
import plotly.express as px
import plotly.graph_objects as go
import re
import warnings
import datetime
warnings.filterwarnings('ignore')
sb.set_style("darkgrid")
%matplotlib inline


# load data
df = pd.read_csv("cleaned_data/reddit_cleaned_2020.csv")
df_merged = pd.read_csv("cleaned_data/reddit_merged_2020.csv")

df_users = pd.read_csv("cleaned_data/users_cleaned.csv")
df_users['user_created_at'] = pd.to_datetime(df_users['user_created_at'], format='%Y-%m-%d %H:%M:%S')
df_users = df_users[(df_users['user_created_at'].dt.year < 2021) |
        (~df_users['user_created_at'].notnull())]


# convert to datetime
df.created_at = pd.to_datetime(df.created_at)
df_merged.created_at = pd.to_datetime(df_merged.created_at)
df_merged.user_created_at = pd.to_datetime(df_merged.user_created_at)
df_users.user_created_at = pd.to_datetime(df_users.user_created_at)


df.shape[0]

128408


px.bar(data_frame=df['submission_comment'].value_counts().to_frame().reset_index(),
       x="index", y="submission_comment", color='submission_comment', text = 'submission_comment' ).update_layout(title='Comment or Submission',
                   xaxis_title='contribution category',
                   yaxis_title='number of contributions').update_traces(marker_color='#5296dd')


df['submission_comment'].value_counts().to_frame().reset_index()


fig = px.pie(data_frame=df['submission_comment'].value_counts().to_frame().reset_index(), values='submission_comment', names='index',
             title='Comment or Submission')
fig.show()


round(df['submission_comment'].value_counts() / df.shape[0] * 100,2)

comment       93.86
submission     6.14
Name: submission_comment, dtype: float64


df.author.value_counts().to_frame().head(10).reset_index()


fig = px.bar(df.author.value_counts().to_frame().head(10).reset_index(), x="author", y="index",
             height=500,
             title='Most commented user in 2020').update_traces(marker_color='#5296dd',).update_layout(
                   xaxis_title='number of comments',
                   yaxis_title='user name').update_traces(marker_color='#5296dd')

fig.update_yaxes(autorange="reversed")


round(df[df.author == '-banned-'].shape[0] / df.shape[0]*100,2)

13.55


df.author.value_counts()[:20]

-banned-                17396
AutoModerator            1679
5th_Law_of_Robotics       298
CelebBattleVoteBot        282
Support_Johnny_Depp       256
DerHander                 237
fluidmoviestar            200
empatheticapathetic       114
AutoNewsAdmin             105
wiklr                     104
pacmatt27                 104
cracksniffer666            99
gaul66                     96
toutfilm                   95
rMemesMods                 89
controlandr3sistanc3       89
Lethal_bizzle94            88
Egalitarianwhistle         80
Princess-La-Felix          80
AG_GreenZerg               79
Name: author, dtype: int64


df_auto_moderator = df.query(" author == 'AutoModerator' ").reset_index(drop=True)
print(df_auto_moderator.shape)
df_auto_moderator.head(1)

(1679, 17)


df_auto_moderator.subreddit.value_counts().head(10)

r/JerkOffToCelebs         311
r/Celebhub                176
r/memes                   169
r/OutOfTheLoop            135
r/unpopularopinion        100
r/AskReddit                99
r/iamatotalpieceofshit     66
r/DC_Cinematic             61
r/CelebBattleLeague        47
r/Drama                    31
Name: subreddit, dtype: int64


df_auto_moderator['permalink'].iloc[26]

'/r/JerkOffToCelebs/comments/etthnt/imagine_amber_heard_laying_on_top_of_you_like_this/ffifkd6/'


df_auto_moderator.text.value_counts().head()

Make sure to follow our community guidelines.\n\n**[Get user flair](https://redd.it/e0a4mn) and check out our [Instagram page](https://www.instagram.com/celebtag) for more celebrity content!**\n\n\n*I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/Celebhub) if you have any questions or concerns.*                                                                                                                                                                                                                                                                                                                                                                                                                                143
Rule 9 overused. No Johny Depp or Amber Heard memes at this time\n\n*I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/memes) if you have any questions or concerns.*                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     105
**PLEASE READ ALL OF THIS BEFORE MESSAGING US:**\n\nThank you for your submission, but it has been removed due to lack of context.  \n\n**Please see Rule 2** and repost with a **URL or a screenshot** (you can host it on imgur.com) **in your submission body** so that the users can better know what you're talking about and increase your chances for getting an answer.  **Feel free to repost once you find a URL.**  (Please remember to include the full URL: URL shorteners don't count.) Thanks!\n\n*I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/OutOfTheLoop) if you have any questions or concerns.*                                                                                                                  87
Your opinion about celebrity relationships has been reposted dozens of times today. Please join a celebrity gossip sub. Thanks.\n\n*I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/unpopularopinion) if you have any questions or concerns.*                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            68
Your submission has been automatically removed for not including a valid category/subcategory tag. Tags are essential to an optimal browsing experience for our users.\n\nSince your post was removed automatically, you are free to resubmit it with an appropriate tag. You can find the tagging guide [here](/r/DC_Cinematic/wiki/linkflair#wiki_automated_tagging). Add a valid and appropriate tag in your submission title. Choose wisely, as posts with misleading tags are subject to removal.\n\n**Message the moderators if your post was removed despite being tagged with an input from the category list.**\n\n\n*I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/DC_Cinematic) if you have any questions or concerns.*     61
Name: text, dtype: int64


df_5th_Law_of_Robotics = df.query(" author == '5th_Law_of_Robotics' ").reset_index(drop=True)
print(df_5th_Law_of_Robotics.shape)
df_5th_Law_of_Robotics.head()

(298, 17)


df_5th_Law_of_Robotics['permalink'].iloc[0]

'/r/LeftWingMaleAdvocates/comments/eu0fth/petition_to_remove_amber_heard_from_aquaman_2_due/ffk1d8o/'


df_5th_Law_of_Robotics.subreddit.value_counts().head(10)

r/videos                   93
r/MensRights               34
r/Egalitarianism           31
r/iamatotalpieceofshit     30
r/LeftWingMaleAdvocates    29
r/SRSsucks                 19
r/agedlikemilk             14
r/Toxic_Femininity          8
r/entertainment             8
r/meToo                     7
Name: subreddit, dtype: int64


df_5th_Law_of_Robotics.text.value_counts().head()

Amber Heard, facing criminal sentencing for lying about abuse, doubles down by suddenly remembering being raped                                                                                                                                                                                                                                       2
No                                                                                                                                                                                                                                                                                                                                                    2
You mean UN Human Rights Champion Amber Heard is a monster.\n\n\nAnd feminist and MeToo darling and domestic violence activist.                                                                                                                                                                                                                       1
Yep                                                                                                                                                                                                                                                                                                                                                   1
\n>Johnny has 19 eyewitness statements, 87 surveillance videotapes, audio (which rekindled this case) and video recordings that he has submitted to his lawyer.\n>\n\n\n\n\nIt's amazing that a man with all that against a woman who just said she was abused with no/contradictory evidence gets people thinking both were equally in the wrong.    1
Name: text, dtype: int64


df_Support_Johnny_Depp = df.query(" author == 'Support_Johnny_Depp' ").reset_index(drop=True)
print(df_Support_Johnny_Depp.shape)
df_Support_Johnny_Depp.head()

(256, 17)


df_Support_Johnny_Depp['permalink'].iloc[0]

'/r/entertainment/comments/fubrmn/amber_heard_hired_private_investigator_to_dig_up/'


df_Support_Johnny_Depp.subreddit.value_counts().head(10)

r/entertainment           117
r/MensRights               39
r/pussypassdenied          32
r/videos                   27
r/SupportForTheAccused     20
r/todayilearned            11
r/Petition                  4
r/movies                    3
r/beauty                    1
r/JusticeServed             1
Name: subreddit, dtype: int64


df_Support_Johnny_Depp.text.value_counts()

Johnny Depp & Amber Heard Abuse Claims: Australia's Bloody Aftermath! NEW UNCENSORED AUDIO!!            11
Johnny Depp & Amber Heard Case Update: Amber's Parents Sided With Johnny? - NEW TEXTS & EVIDENCE!! -    10
Sign the Petition: Remove Amber Heard as L'Oreal Spokesperson                                            8
Johnny Depp & Amber Heard: The Truth and Timeline of The Case                                            6
Johnny Depp & Amber Heard Abuse Claims: Amber "just lost it" so Johnny LOST A FINGER! NEW EVIDENCE!!     6
                                                                                                        ..
Sign the Petition: Remove Amber Heard as L'Oreal Spokesperson #justiceforjohnnydepp                      1
Petition To Drop Amber Heard from 'Aquaman 2' Nears Half a Million Signatures                            1
Johnny Depp Deposition Describing His Finger As Mount Vesuvius, and Covering for Amber Heard!            1
PROOF Amber Heard S**T IN Johnny Depp's BED - And MORE!                                                  1
The Petition To Remove Amber Heard From Aquaman 2 Hits Over 400K Signatures                              1
Name: text, Length: 141, dtype: int64


df_users[df_users.user_name == 'DerHander']


'This user created at 2017'

'This user created at 2017'


df_DerHander = df.query(" author == 'DerHander' ").reset_index(drop=True)
print(df_DerHander.shape)
df_DerHander.head()

(237, 17)


df_DerHander.subreddit.value_counts().head(10)

r/femcelebs             147
r/celeb_blondes          21
r/Blonde                 21
r/FamousFaces             6
r/FamousBabes             6
r/cleavage                4
r/sexycelebs              4
r/celeb_bellybuttons      3
r/legs                    3
r/Celebrityasses          2
Name: subreddit, dtype: int64


df_DerHander.text.value_counts().head(10)

Amber Heard                                                                            212
Idgaf                                                                                    1
I know what you wanted to allude to.                                                     1
Yes, but the sexy one.                                                                   1
Amber Heard & Gal Gadot                                                                  1
But a hot liar                                                                           1
Yes, but I give a fuck. I post what I like. If you want you can post what you like.      1
Amber Heard vs. Elisabeth Moss                                                           1
Not "but", "and".😜                                                                       1
I don't see a problem for me. They'll have to work that out for themselves.              1
Name: text, dtype: int64


# check the date this account was creted
str(df_users[df_users.user_name == 'fluidmoviestar']['user_created_at'].values[0])

'2015-04-30T04:23:28.000000000'


df_fluidmoviestar = df.query(" author == 'fluidmoviestar' ").reset_index(drop=True)
print(df_fluidmoviestar.shape)
df_fluidmoviestar.head()

(200, 17)


df_fluidmoviestar.subreddit.value_counts().head(10)

r/unpopularopinion    200
Name: subreddit, dtype: int64


df_fluidmoviestar['text'].value_counts()

Oh, so much evidence.\n\nI appreciate wanting to give people the benefit of the doubt, but when reasonable doubt is gone, defending a monster only makes anyone or anything associated with the abuser look foolish for their insistence.                                                                                                                                                                                                                                                                                                1
He represents a male form of extracting value from victims. She represents a female form of the same. It’s just a point of comparison around the same tired topics of what constitutes abuse, consent, power, etc.                                                                                                                                                                                                                                                                                                                       1
Perjury is a criminal offense. Time will tell.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           1
It’s hyperbolic, yes, but the point was to draw attention to differing strategies that male abusers and female abusers use to silence their victims and generate codependency. That’s all.                                                                                                                                                                                                                                                                                                                                               1
That’s a fact, though I don’t see how they ever get us to mind-control. Maybe we secretly have the brain better mapped out than popularly understood.                                                                                                                                                                                                                                                                                                                                                                                    1
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        ..
In what way is his behavior toxic? You think I’m 17, but this is your level of engagement with a case of a distinct man and woman preying on their victims? Men don’t commit crimes for reasons identical to women. Equivalence needn’t be viewed as identical. Harvey sparked metoo, Amber threatens its legitimacy. She is a criminal, and a prison sentence is suitable for her crimes, although at a lower number of years, as her crimes are not identical to Harvey’s.                                                             1
Kudos                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    1
Harvey didn’t take advantage of partners, correct. Amber did. I find that more offensive. Most of the things Harvey did (but wasn’t convicted of) were temporary sexual situations with voluntarily complying strangers, not intimate partners with legal obligations holding victim and victimizer in a race to the bottom. Seek clarification, but don’t assume of me.                                                                                                                                                                 1
Different countries, different challenges. The US’s male/female ratio is nowhere near as screwed as India’s. \n\nThat said, Jeffery Epstein “suicided” because of endless trafficking and abuse. He’s not the only one. Hearing about something isn’t the measure of whether or not something happens. The tree still falls in the woods.\n\nI stand by it, India is no more deserving of attention for rape than any other country. Titles like that might unnecessarily convince people to ignore the issue in their own countries.    1
Okay, where’s the article?                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               1
Name: text, Length: 200, dtype: int64


df_fluidmoviestar_g = df_fluidmoviestar.groupby(df_fluidmoviestar.created_at.dt.date).size().reset_index(name='n_contributions')
df_fluidmoviestar_g


fig = px.bar(df_fluidmoviestar_g,
             x='created_at', 
             y='n_contributions', title='The number of "fluidmoviestar" contributions in 2020')

fig.update_layout(
    xaxis = dict(
        title='Contribution Date',
        tickmode = 'array',
        tickvals = df_fluidmoviestar_g.created_at,
    )
)

fig.update_traces(marker_color='#5296dd',
                  marker_line_width=2, opacity=1, textposition='auto')
fig.show()


fig = px.bar(df_fluidmoviestar[df_fluidmoviestar.created_at.dt.day == 19].created_at.dt.hour.value_counts().to_frame().sort_index())
fig.update_layout(
    title="title='Number of Contribution in each hour of 19 may 2020 '",
    xaxis_title="Hour of day 0-23",
    yaxis_title="n_of_contributions",
    showlegend=False,
    xaxis = dict(
        tickmode = 'linear')

)


fig = px.bar(df_fluidmoviestar[df_fluidmoviestar.created_at.dt.day == 20].created_at.dt.hour.value_counts().to_frame().sort_index())
fig.update_layout(
    title="title='Number of Contribution in each hour of 20 may 2020 '",
    xaxis_title="Hour of day 0-23",
    yaxis_title="n_of_contributions",
    showlegend=False,
    xaxis = dict(
        tickmode = 'linear')

)


df_empatheticapathetic = df.query(" author == 'empatheticapathetic' ").reset_index(drop=True)
print(df_empatheticapathetic.shape)
df_empatheticapathetic.head()

(114, 17)


df_empatheticapathetic.subreddit.value_counts().head(10)

r/MensRights              63
r/iamatotalpieceofshit    14
r/WeinsteinEffect         14
r/awfuleverything          7
r/pussypassdenied          5
r/PussyPass                4
r/Toxic_Femininity         3
r/entertainment            2
r/PurplePillDebate         1
r/JusticeForJohnnyDepp     1
Name: subreddit, dtype: int64


df_empatheticapathetic.text.value_counts()

Course fam, you know how it be.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        1
Yeah it wasn't the woman who bragged about abusing her partner and **bragging about the fact she will get away with it because she's a girl**. No it's a very confusing case 🤔.\n\nIt's not like she has a history of domestic abuse with her other partne-oh wait...\n\nYou on the other hand have a clear "women good men bad" agenda. And most men have been shocked awake by this recent Johnny Depp case. The plausible deniability is gone and you feminists trying to do damage control are displaying your bigotry in plain sight.\n\nHey, you wanted 'equality'. Here it is.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  1
What do you think about all the claims of harassment that he wasn't convicted on?                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      1
This whole thing has been a bit of a revelation. Him actually losing in court has swayed so much more public support to his side than if he won. But we honestly couldn’t have expected that to happen.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                1
How dumb are you? One gender is getting punished and one gender isn’t for the same crimes? And you ask this question on a post about how people believed Amber Heard over Johnny Depp because he was a man and she was a woman?\n\nWhat website are you talking about?\n\nHow old are you? For real? I don’t want to hurt you with too much logic if you aren’t really old enough to be debating on the internet. \n\nLet’s get amber heard behind bars first. Sound like a good plan? The first step would be to get women like you who have a clear agenda to admit Amber Heard is a disgusting human being, a liar, an abuser and that she should be in jail. And then when I feel like you are representing equality, I will do the same.\n\nMen don’t get off for crimes. They even go to jail for false crimes. Check out /r/falserapeaccusations You can see a list of crimes that women get away with over at /r/pussypass \n\nGlad to hear you’re finally on the right side of history. Now let’s go get those women in jail!!                                                                                                                                                                                                                                                                1
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      ..
Won’t happen                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           1
Censorship here is being downvoted until you can’t be seen, even if you are stating facts. So yes, I am not allowed to acknowledge and discuss the misandrist agenda in society and on this sub.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       1
Have you not noticed that?                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             1
>No it isn’t. It didn’t start off that way. It was actually from a black woman who was sick of getting cat called and realized in her environment she was more exposed to harassment. And nobody cared. Please don’t tell me that that is BS.\n\nWho gives a fuck how it started. We're talking about how it is utilised now.\n\n>False accusations exist yes but that doesn’t take away from what the initial goal was from the moment — raising awareness.\n\nWow you sound empathetic. Raising awareness is worthless and creates a toxic culture where anyone can accuse anyone else of anything and people will believe it instead of waiting for legal discourse. We have a full legal system in place for this.\n\nBut hey if you want women to keep losing credibility through bullshit movements like metoo, then be my guest. You'll be the one losing out as less and less women are trusted or believed as a result of this entitled selfish thinking.\n\nYour agenda is crystal clear. Why are you on mens rights if you don't care about mens rights?                                                                                                                                                                                                                                    1
>I said it’s unfortunate everyone rallied behind this case that he abused her without correct information an it ended up her the abuser. I said all this support came off the me too movement and people decided to back up the wrong situation because she ended up being the abuser.\n\nWomen and idiot men push the narrative #believewomen. "Women couldn't possibly lie." All the evidence was stacked against her for years but instead people 'cancelled' Johnny Depp because abuser=male and victim=female, and Amber Heard became a womens rights ambassador of domestic abuse. And here you are in your other comment still defending her and again trying to twist the narrative. You're a fucking agenda ridden feminist piece of shit, and now your type is being called out for the hypocrites you really are.\n\nWomen support other women, like you're doing here. Because you gain the social power and leverage to 'cancel' people like you cancelled Johnny Depp whenever you want, with bullshit movements like #metoo (guilty before being proven innocent) and #believewomen (because women are incapable of lying). Go ask the guys over at /r/falserapeaccusations whether they #believewomen.\n\nYou have only proven women are a hivemind and that you are a huge sexist.    1
Name: text, Length: 114, dtype: int64


df_empatheticapathetic['permalink'].iloc[5]

'/r/iamatotalpieceofshit/comments/ex9ge9/amber_heard_admits_abusing_johnny_depp_even/fg85ohq/'


# check the date this account was creted
str(df_users[df_users.user_name == 'AutoNewsAdmin']['user_created_at'].values[0])

'2016-10-27T00:30:08.000000000'


df_auto = df.query(" author == 'AutoNewsAdmin' ").reset_index(drop=True)
print(df_auto.shape)
df_auto.head()

(105, 17)


df_auto.subreddit.value_counts().head(10)

r/GUARDIANauto       19
r/INDEPENDENTauto    17
r/BBCauto            11
r/SCMPauto           10
r/IOLauto             9
r/CHICAGOTRIBauto     9
r/SMHauto             7
r/TELEGRAPHauto       5
r/IRISHTIMESauto      4
r/TORONTOSTARauto     4
Name: subreddit, dtype: int64


df_auto_contributions = df_auto.groupby(df_auto.created_at.dt.date).size().reset_index(name='n_contributions')
df_auto_contributions


df_auto.text.value_counts()

[World] - Amber Heard denies fabricating injuries after Johnny Depp allegedly threw phone at her    2
[World] - Johnny Depp threatened to kill me, Amber Heard tells court                                2
[World] - Johnny Depp’s ex-wife Amber Heard accused of ‘stealing’ sex abuse story                   1
[World] - Amber Heard says ex-husband Johnny Depp threatened to kill her                            1
[World] - ’He’s nuts Mom’ - Amber Heard shared fears about Johnny Depp in 2013                      1
                                                                                                   ..
[UK] - Johnny Depp and Amber Heard: Couple rowed 'like schoolchildren', says ex-employee            1
[UK] - Trolls, tweets and famous friends: the vicious PR war between Johnny Depp and Amber Heard    1
[World] - Amber Heard denies fabricating injuries in Depp libel trial                               1
[World] - Johnny Depp threw bottles 'like grenades', former wife Amber Heard says                   1
[UK] - Johnny Depp 'insulted by Amber Heard during Bahamas trip', says his employee                 1
Name: text, Length: 103, dtype: int64


df_pacmatt27 = df.query(" author == 'pacmatt27' ").reset_index(drop=True)
print(df_pacmatt27.shape)
df_pacmatt27.head()

(104, 17)


df_pacmatt27['permalink'].iloc[0]

'/r/MensRights/comments/jprmy5/petition_to_have_amber_heard_removed_as_the/gbgqrp7/'


df_pacmatt27.subreddit.value_counts().head(10)

r/MensRights    104
Name: subreddit, dtype: int64


df_pacmatt27.text.value_counts().head(15)

Please do.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            2
Just curious how you can identify with a movement which has essentially become a hate group?                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          2
K, bye.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               2
K.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    2
Not sure how to phrase that question more simply.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     1
I am. Next.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           1
Ok but can you actually show me any rights men have which women don't in developed countries? Y'no, ones that aren't total shitholes. Can you give me real examples of what feminism can actually do to be of value? Not parroted rhetoric and a gross misunderstanding of human history.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             1
I wish I could too but you keep irritating me.\n\nGot plenty. Fuck off.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               1
You are indeed. Now go away.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          1
Just behaving like feminists do. It's irritating isn't it? When you start actually investing some effort in helping men, I'll stop comparing suffering. Since, apparently, we have to fix all the most important issues first and all of those involve women making shit up.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          1
I can't m8, covid-19.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 1
So what you're saying is you're a simpleton?                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          1
Not really.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           1
> There are multiple different branches of Feminism.\n\nPlease don't patronise me. I'm more than aware of that. \n\n>The type you're probably referring to is radical feminism which is more anarchist in nature.\n\nWrong, I am referring to mainstream third wave feminism, which is the most popular form of feminism at present.\n\n>Most Feminists you'll meet in real life literally just want equity for genders\n\nWrong. Most feminists I meet in real life are hypocrites with a startling lack of awareness of male issues, an inability to react to dissent rationally and a spiteful, greedy, vengeful victim complex.\n\n>Anti-men feminists are the exception, not the rule.\n\nWrong and, even if they were, they are not the ones informing social and legal policy and lack the power to do anything meaningful.    1
No, I see what is actually there.\n\nYeah, that's bullshit. When you want to discuss this like someone with integrity would, you let me know.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         1
Name: text, dtype: int64


df_wiklr = df.query(" author == 'wiklr' ").reset_index(drop=True)
print(df_wiklr.shape)
df_wiklr.head()

(104, 17)


df_wiklr['permalink'].iloc[0]

'/r/DeFranco/comments/ex0ifz/full_audio_recording_of_amber_heard_and_johnny/fg9qcsr/'


df_wiklr.subreddit.value_counts().head(10)

r/entertainment          25
r/videos                 20
r/WeinsteinEffect        19
r/AskWomen                7
r/television              7
r/unpopularopinion        5
r/NoStupidQuestions       4
r/harrypotter             3
r/meToo                   2
r/CaptainSparrowmemes     2
Name: subreddit, dtype: int64


df_wiklr.text.value_counts().head(15)

Yes, the Bieber accusations were unvetted but publications printed it anyway because he denied it. Holding the media to a higher standard was my point in the previous thread.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                1
Back then she did have enough evidence leaked to sway public opinion. \n\nShe went to court with bruises, she had additional photos / expose in People Magazine, one of her friends wrote an article why they called 911. There was a video showing Johnny having a drunken outburst. She had more things that sold clicks. \n\nWhile Johnny's family & friends, former partners were vouching for him. Amber's arrest records were dug up including her mug shots and the DV case against her ex-gf Tasya. Her demand for the 50k a month spousal support, 3 penthouses and car for a mutual settlement was leaked. Her TRO was dismissed with prejudice. There was enough to insert doubt but not enough to defend himself. \n\nHis defense - PR wise wasnt enough to debunk her claims. While the deposition that includes the tape were available back in 2016, it was hidden under their mutual NDA and the $7M settlement he gave Amber. It made it look like hush money. What's worse is the statement that they released stated how no one fabricated evidence for financial gain. \n\nAdditional video surveillance / evidence in his defense was uncovered much later after Johnny reached a settlement with his former lawyers.    1
There's two released this week: \n\n* [2015 Audio Recording](https://www.dailymail.co.uk/news/article-7947733/Amber-Heard-admits-hitting-ex-husband-Johnny-Depp-pelting-pots-pans-tape.html): Discusses their fight with Amber admitting she hit, chased and instigated fights with Depp (recorded using Heard's phone)\n* [May 2016 Phone Call](https://www.dailymail.co.uk/news/article-7966723/Amber-Heard-ridicules-Johnny-Depp-claiming-hes-domestic-violence-victim.html): Happened after Heard accused Depp of domestic abuse (recorded by Depp)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       1
He wasn't in a good place to fight anything at that time. His finances in jeopardy, issues with his lawyers, his mother died, his new wife not only divorcing him but also accusing him of domestic abuse. \n\nHe was fine going to court but Amber was seeking spousal support for a settlement. In the tape he was asking for things to end peacefully. In hindsight it was a mistake for him to settle and not take Amber to court. \n\nThe reason the tapes are out now is because its part of a trial against The Sun. I think he is now fighting to clear his name legally, instead of using the media like Amber does.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 1
I went back. Her lawyers first said that Depp is lying about Amber's abuse being one of them. Compared to a recent statement acknowledging Depp was also a victim - and this only after the audio tapes were leaked. \n\nAmber Heard's domestic violence case was dismissed with prejudice but you never heard about it in the news. Everyone only heard about her filing the restraining order, getting a $7M settlement and donating it to charity.\n\nThe silence about their deposition where Amber lied multiple times is deafening. A lot of these details were published way in 2016 but didn't make major news publications.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          1
* The DM link points to Josh's deposition video that mentions Cara & Elon\n* The lie was she first made it look like she was fleeing from Johnny's abuse but the audio tells the opposite and she was trying to get in the bathroom (door swings inwards thereby JD getting hit). In another audio she specifically recounts how JD always leaves when they fight which corroborates a pattern of her getting physical, and he splits. \n* Under 9/12/2019 - Defendant's Motion to Compel: \n\n> documents and communications between ... any of plaintiff's [romantic partners](https://imgur.com/a/Xbm4GBE) from 2010 to present\n\nAmber argued that JD should prove he has never hit a woman and instead subpoenaed his exes. Else there would be no need for Vanessa or Winona to make declarations, nor for them to be compelled & accepted to testify in the adjacent Sun/NGN lawsuit.                                                                                                                                                                                                                                                                                                                                                 1
Yeah Elon Musk was Amber Heard's rebound following her accusations against Depp. \n\nElon broke up with her citing different work schedules. I kinda wonder if Elon suffered the same fate or believes Depp now.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              1
Tasya called the police on Amber Heard. Beverly was very vocal about this on facebook and was clear on her arrest about Heard. You were adamant it was a male officer but why did you not include the gay female cop who arrested her? They didn't mention the gender of the other officer you're saying. So what's his name?                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 1
Rumor is Elon Musk is paying for Amber Heard's legal team. \n\nI was wondering how she got so much media and legal backing, against an A List celebrity no less. It was because she was seeing Musk before she got her divorce.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               1
I read the case files, then read your comment and was surprised this was published before. \n\nThey say Stephen's message is proof but it doesn't seem like he was a witness. He was relaying to Depp what Heard told him. Weaponizes his apology as an admittance of guilt even if he doesn't remember what happened. Still not really as damning as the audio tapes, which is labeled "first" by Depp's lawyer. \n\nSo far the audio confession is the only definitive proof of one of them being abusive.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  1
No it actually happened(2016) a year prior MeToo. But it caught steam again when JK defended his casting Fantastic Beasts(2017), then the WaPo article(2018).                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 1
* The specific deposition that involves Elon & Cara can be found [here](https://www.dailymail.co.uk/news/article-8426719/Cara-Delevingne-three-way-affair-Amber-Heard-Elon-Musk.html).\n* Another deposition where Amber is caught lying by her own audio tape is [here](https://youtu.be/-sKyN0_D_ec). \n* Other transcripts of depositions can be found in Amber & Johnny's declaration available on the [fairfax website.](https://www.fairfaxcounty.gov/circuit/high-profile-cases)\n* You are correct it is about a defamation case. But it is more sensational to think the story is about a three-way affair rather than them being witnesses for the lawsuit. \n* Also if the issue is making it about sexual partners, you should ask Amber why she subpoenaed Johnny's exes like Winona Ryder, Angelina Jolie, Ruth Wilson, & others.                                                                                                                                                                                                                                                                                                                                                                                               1
People came after Rowling so hard for defending Depp too. And it took 4 years to any of this to come to light. \n\nIf it isn't the right time to reevaluate how the fanbase reacts to news now, idk when that time will come.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 1
Not planning but corroboration. Her lawyers have been avoiding a trial for this very reason because her own parents, her own recording claims she pursued the restraining order in fear she will lose the condos housing her friends. Same friends who corroborated her restraining order that was dismissed with prejudice, same friends who went to the media to corroborate her abuse allegations.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         1
There was where the doctor said she did it and Amber said sorry and she didn't mean to. They all lied how Johnny's finger was cut off at that time because it would've been a huge scandal. But the judge only considered Amber's testimony in court and the inconsistent reasons his body guards made and Johnny's own text to the same doctor.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              1
Name: text, dtype: int64


df.author.value_counts().nlargest(n=25)

-banned-                17396
AutoModerator            1679
5th_Law_of_Robotics       298
CelebBattleVoteBot        282
Support_Johnny_Depp       256
DerHander                 237
fluidmoviestar            200
empatheticapathetic       114
AutoNewsAdmin             105
wiklr                     104
pacmatt27                 104
cracksniffer666            99
gaul66                     96
toutfilm                   95
rMemesMods                 89
controlandr3sistanc3       89
Lethal_bizzle94            88
Egalitarianwhistle         80
Princess-La-Felix          80
AG_GreenZerg               79
bufedad                    78
Threwaway42                77
reptilesocks               74
AutoNewspaperAdmin         71
EtherMan                   68
Name: author, dtype: int64


check_list = df.author.value_counts().nlargest(n=25).index.tolist()[1:]
check_list

['AutoModerator',
 '5th_Law_of_Robotics',
 'CelebBattleVoteBot',
 'Support_Johnny_Depp',
 'DerHander',
 'fluidmoviestar',
 'empatheticapathetic',
 'AutoNewsAdmin',
 'wiklr',
 'pacmatt27',
 'cracksniffer666',
 'gaul66',
 'toutfilm',
 'rMemesMods',
 'controlandr3sistanc3',
 'Lethal_bizzle94',
 'Egalitarianwhistle',
 'Princess-La-Felix',
 'AG_GreenZerg',
 'bufedad',
 'Threwaway42',
 'reptilesocks',
 'AutoNewspaperAdmin',
 'EtherMan']


# get a data frame with the most negative-comments users
df_check = df_users[df_users['user_name'].isin(check_list)]
print(df_check.shape)
df_check.head(2)

(24, 10)


df_check['user_name'].nunique()

24


for col in df_check.columns:
    if col not in ['user_name', 'user_created_at']:
        print('The value counts of the users with the most contributions: ' + col)
        print(df_check[col].value_counts())
        print('\n')

The value counts of the users with the most contributions: has_verified_email
True     21
False     3
Name: has_verified_email, dtype: int64


The value counts of the users with the most contributions: is_mod
True     18
False     6
Name: is_mod, dtype: int64


The value counts of the users with the most contributions: is_gold
False    17
True      7
Name: is_gold, dtype: int64


The value counts of the users with the most contributions: is_banned
False    20
True      4
Name: is_banned, dtype: int64


The value counts of the users with the most contributions: comment_karma
 100113.0    1
 56411.0     1
 149876.0    1
 1000.0      1
 93039.0     1
 10.0        1
-100.0       1
 213108.0    1
 36552.0     1
 73.0        1
 77741.0     1
 219601.0    1
 361.0       1
 1370.0      1
 46342.0     1
 9738.0      1
 6637.0      1
 5629.0      1
 1063.0      1
 1.0         1
Name: comment_karma, dtype: int64


The value counts of the users with the most contributions: link_karma
1.0         2
681.0       1
1289.0      1
1000.0      1
6145.0      1
2484.0      1
301.0       1
249122.0    1
14476.0     1
245787.0    1
366459.0    1
25821.0     1
1925.0      1
20315.0     1
1632.0      1
36237.0     1
4746.0      1
7398.0      1
698.0       1
Name: link_karma, dtype: int64


The value counts of the users with the most contributions: banned_unverified
others        17
banned         4
unverified     3
Name: banned_unverified, dtype: int64


The value counts of the users with the most contributions: creation_year
others    12
2019       5
banned     4
2018       2
2020       1
Name: creation_year, dtype: int64


df_check['comment_karma'].mean(), df_check['comment_karma'].median()

(50928.25, 8187.5)


df_check['comment_karma'].min(), df_check['comment_karma'].max()

(-100.0, 219601.0)


df_check['link_karma'].mean(), df_check['link_karma'].median()

(49325.9, 3615.0)


df_check['link_karma'].min(), df_check['link_karma'].max()

(1.0, 366459.0)


# pd.set_option('display.max_colwidth', None)
suspected_dict = {}


df_fuc = df[df.text.str.lower().str.contains('fuck')]
print(df_fuc.shape)
df_fuc.head()

(8468, 17)


f'{round(8468 / df.shape[0] * 100,2)} percent used f*ck work'

'6.59 percent used f*ck work'


# get the authors of these submissions having the same submission text

mask = (df['submission_text'] == 'fuck_amber_heard') & (df['submission_comment'] == 'submission')
df_sub = df[mask]
print(df_sub.shape)

with pd.option_context('display.max_colwidth', None):
  display(df_sub.head())

(52, 17)


# get the authors of these submissions having the same submission text

mask = (df['submission_text'].str.contains('fuck')) & (df['submission_comment'] == 'submission')
df_sub_fuc = df[mask]
print(df_sub_fuc.shape)

with pd.option_context('display.max_colwidth', None):
  display(df_sub_fuc.head())

(235, 17)


df_fuc.author.value_counts().head(15)

-banned-              929
cracksniffer666        20
pacmatt27              19
AutoModerator          17
myIDateyourEGO         15
king_of_red_alphas     13
oTHEWHITERABBIT        12
FuckCoolDownBot2       12
Ryggg95                12
TheWizardChrist        11
akmetalhead            10
Doodle-DooDoo          10
azobran22              10
Usual_Class            10
immortalsperm          10
Name: author, dtype: int64


df_fuc.submission_comment.value_counts()

comment       8130
submission     338
Name: submission_comment, dtype: int64


df_fuc.subreddit.value_counts().head(10)

r/videos                  1797
r/awfuleverything          598
r/entertainment            554
r/MensRights               525
r/pussypassdenied          522
r/JerkOffToCelebs          399
r/memes                    351
r/iamatotalpieceofshit     350
r/TrueOffMyChest           193
r/AskReddit                146
Name: subreddit, dtype: int64


df_fuc


df_fuc.created_at.dt.date.value_counts().to_frame().reset_index().rename(columns={'index': 'date',
                                                                                 'created_at': 'n_contributions'})


fig = px.bar(df_fuc.created_at.dt.date.value_counts().to_frame().reset_index().rename(columns={'index': 'date',
                                                                                 'created_at': 'n_contributions'}),
             x='date', 
             y='n_contributions', title='The number of submissions with the word "F*CK" in 2020')
fig.update_traces(marker_color='red', marker_line_width=0.5, opacity=1, textposition='auto') 
# , marker_line_color='#5296dd'

fig.show()


df_fuc.created_at.dt.date.value_counts().head(10)

2020-02-04    701
2020-11-07    486
2020-02-08    421
2020-02-02    396
2020-02-07    330
2020-02-05    328
2020-12-16    287
2020-02-09    260
2020-02-06    247
2020-11-08    236
Name: created_at, dtype: int64


df_fuc.author.value_counts().head(10)

-banned-              929
cracksniffer666        20
pacmatt27              19
AutoModerator          17
myIDateyourEGO         15
king_of_red_alphas     13
oTHEWHITERABBIT        12
FuckCoolDownBot2       12
Ryggg95                12
TheWizardChrist        11
Name: author, dtype: int64


df_fuc.submission_comment.value_counts()

comment       8130
submission     338
Name: submission_comment, dtype: int64


df_fuc.subreddit.value_counts().head(10)

r/videos                  1797
r/awfuleverything          598
r/entertainment            554
r/MensRights               525
r/pussypassdenied          522
r/JerkOffToCelebs          399
r/memes                    351
r/iamatotalpieceofshit     350
r/TrueOffMyChest           193
r/AskReddit                146
Name: subreddit, dtype: int64


df_fuc_contributions = df_fuc.groupby(df_fuc.created_at.dt.date).size().reset_index(name='n_contributions')

fig = px.bar(df_fuc_contributions,
             x='created_at', 
             y='n_contributions', title='The number of "F*CK" contributions in 2020')
fig.update_traces(marker_color='red', marker_line_width=0.5, opacity=1, textposition='auto') 
# , marker_line_color='#5296dd'

fig.show()


df_fuc_contributions.sort_values('n_contributions', ascending=False).head(10)


df_cracksniffer666 = df.query(" author == 'cracksniffer666' ")
print(df_cracksniffer666.shape)
df_cracksniffer666.head()

(99, 17)


df_cracksniffer666.groupby(df_cracksniffer666.created_at.dt.date).size().reset_index(name='n_contributions')


df_cracksniffer666.text.value_counts().head(3)

I'm just scared knowing people upvoted you thinking you were serious.                                                                      1
Go look at the pinned post on my profile.... Lol                                                                                           1
I know if I raised a baby girl for 18 years and saw her ass on the internet, I'd be internally sad. The end. Agree to disagree I guess.    1
Name: text, dtype: int64


df_cracksniffer666[df_cracksniffer666.created_at.dt.date == datetime.date(2020, 2, 10)].text.values

array(['She cut off his finger, shit in his bed, and would paint bruises on herself to claim abuse from him. A piece of shit. Society is still defending her also.',
       'Explain', "That's pathetic",
       "Username checks out. No. No we can't.", 'Yeah haha',
       "The media is still praising her. Don't believe what you hear. There's still people defending her also. Listen to the therapy tapes... That's all I'll tell you",
       'Preach.', "It's fucked",
       "You're a misogynist for thinking she should be treated as a man would. What world do you live in? EQUALITY.",
       'Yeah, search anywhere for like 5 mins',
       'Nobody here, lol.. You\'re mentally unstable if you\'re defending reddit lol. There are plenty of people that have defended her, or used the classic "deflection" technique, saying "OH, WELL, WHAT DID HE DO TO MAKE HER DO THAT?!" No. No. Get the fuck on outta here with that shit. She got caught being a piece of shit abuser, and now you\'re all gonna see it.',
       "Username checks out, once again. Women are more than 5 times more likely to defend and protect women, no matter the cost, what the woman did, etc. Here's an actual study for you! https://www.apa.org/monitor/dec04/women",
       'Yes. and cut his fucking finger off. or at least the tip. Her on those tapes, degrading him "OH, JOHNNY, no ones ever gonna believe you about the abuse!" that was worse than any of it to me. Just gaslighting the poor dude. She put a lit cigarette out on his face too. Look that picture up.',
       'Yeah, we have to work sex into it somehow, I forgot reddit obsessed about mating... lol jesus.. Get a hobby',
       'google her name. Simply.',
       'I\'ve had 3 or 4 people "go against" what I\'m saying, and they all had weird pixie/witchy/feminine usernames. It\'s truly sad. When do you finally admit you gender can do wrong, as we\'re all human? Living life on easy mode.',
       "Prob won't happen. Which will give the green light to more women aggressors, why do they not see this ending in chaos eventually? The only reason I posted this, is because I was abused, SHE went to jail, and I still lost all my friends from her bullshit lies. SOCIETY NEEDS TO WAKE UP. To think men are so awful, when we're the exact same species as women, is hilarious. Stop giving them the pass to be awful. It's just gotten sad at this point. On another note, I couldn't imagine going to my daughter's Instagram, and seeing her ass. Wtf happened?.......",
       'There was a literal movement about it, you clown. #metoo. Why are people hardwired to neglect abused men? Seriously ask yourself.',
       'Comment on the wrong person, my bad',
       "Why are you winking, on an abuse thread? Is a smiley wink okay if a man abuses someone, just to make your argument valid? You're fucking gross.",
       "I've been in love, and drunkenly defended her. I don't even believe what he's saying, love can fuck you up. He's definitely not told it all, and other crazy stuff she has done.. My ex went to jail twice and no one believed me so, yeah..",
       'Le inkwell*!!!! 1',
       "So you'd get beat up, have your career ruined, and be mentally tortured, for pussy? I hope you work alone, because I can't see women or men respecting you.. That's just gross",
       'Asscrack',
       'Still got screwed in the end.. Lost most of my friends. It\'s called "reputation destruction" and its common now with social media. The modern chicks I know are extremely vindictive.. :(',
       'Say something bad about her then.',
       'Maybe I\'ll meme the Elon musk thing next, since women can do no wrong on reddit. I HAVE TO ASK.... do dudes that blindly defend women on here, think they\'re gonna get laid, by a random, anynomous person? I\'ve never understood that. Is it cognitive dissonance? "well, I defended m\'lady, now I can sleep soundly tonight..." like I literally don\'t know what their main objective is.. I respect my mother, my sister, and the couple chicks I hangout wit/hook up with, and I can\'t see blindly defending someone if they\'re wrong.. My mind just can\'t do it. I\'m glad these Neckbeards aren\'t attourneys/judges... Fuck..',
       'Lies? Women can be awful, too. Either say yes, I agree, or piss off. We\'re aware men can be awful. The past 10 years of Twitter has proven that, but; I want you to say, "women can be awful too" and I\'ll respect you, and listen to what you have to say. I dare you.',
       "Wait, Johnny Depp isn't at fault.", 'Fuck Chris brown too.',
       "It's not a fucking gender thing you Goddamn pussy panderers",
       'Let me Know when Princess Peach is the plumber instead of Mario.',
       "Are you saying shit bounced? Either you're a great troll, or you need counseling. I feel like I'm being fucked with, but I AM on reddit, so who knows",
       'Hahahahahah',
       'Doubts. My Answer is no. Probably get another movie deal knowing Hollywood.',
       "You're wrong dude! Not everyone thinks women can be shitty! Stop projecting. Women defend women 5x more than they would defend a man for the same thing.",
       "Classic shaming, I'm fragile, but you're the one who feels the need to comment to a stranger and tell him who, and what he is..lol. Okay",
       'Damn those 20k upvotes and my weird agenda! Blasted!', 'True',
       'Yeah because this has everything to do with a crazy man. Fuck off.',
       "A worm. I've fell victim to beautiful women before, and it's literally the same thing as a venus fly trap. Just no. Women are beautiful because of biology. If they weren't, we wouldn't be here. But some people try to manipulate others with that advantage. Not cool.",
       'Deal. Lol',
       'What I\'m trying to PROVE, is that Reddit, among other things, aimlessly defend women, no matter the story. You can\'t seem to see that though. I\'m a fucktard. I have 70 IQ and am not worthy to talk to you :( This has everything to do with gender, in this situation. If Depp did this, and there were tapes released, he\'d be in jail. "Amber Heard just seen out with new girlfriend after Johnny Depp audio scandal" Seriously? Google "Amber Heard" and see how they\'re portraying it. WTF is wrong with your brain. Google that, and then IMMEDIATELY listen to the FUCKING ACTUAL AUDIO and form YOUR OWN opinion? Good fucking god, I feel like I\'m going crazy. Just google her and see what the tabloids aren\'t saying. Good luck.',
       "It's sad that healthy, lovely, young women and men are getting shown this shit. It truly upsets me, and I'm scared to have children at this point. If I have a son, I have to worry, if I have a daughter, I have to worry twice as much. Just doesn't seem worth it, wish we could hit the 90s one more time, lol",
       'Lol. Is the chocolate chip cookie a recipe or an invention?',
       "They're video games... Lol. Idk what you want anymore. You broke up with me 3 years ago and now try to comment here...",
       'Hahahaha gotcha bitch!', 'Tell me why, and I might',
       "You need mental help. Youve been indoctrinated, person.. Please explain how I've objectifed anyone, without sounding like and idiot, and/or deleting your comments. Go.",
       'Stop saying stuff like that man',
       "It's reality.. Lemons haven't evolved? Wolves didn't become man's best friend? Allright, let's just leave out the most intelligent species on the planet, no evolution or adaption there. You're right. - ____-",
       "I don't believe in canceling people. She should go to kangaroo court.",
       '5 out of 5 today. Username checks out. I have nothing to say to your superficial ass, lmao',
       "Bruh, it's fake history porn. The subreddit. It's a joke, playing off of something that happened... Lol damn you must be faded like ya boi",
       'Nice.',
       'He was late to her birthday party, I heard, and she placed the shit in the bed.',
       "Who? I've suffered from domestic violence. Act surprised",
       "Lol lackey... Haha. I'm sorry a group of dudes have found out it's not worth it to lose our houses, kids, etc. Boohoo, u mad?",
       "But seriously; are you gonna cry that men have literally one space to chat? I'm assuming you're a low value boring human, rummaging through posts.. Check out femaledatingstrategy or pink pill feminism. Id bet 100 bucks I don't hear back from you after looking there. GL!",
       "It's crazy you can have a driver's license and vote. I hope the rest of your life is easy as it is now sweetheart..",
       "You're a weird lonely troll most likely.", 'Zombieland 2009',
       'Feel free to come on my podcast and air it out',
       "Dude some humans aren't ready for the truth and it scares me.. Like dude.. We're past that point. Lol. We know we're animals, we mate, procreate, etc. Some people still look at life like a fucking Disney movie, as an adult, lol. Cmon now. We're mammals. But trickier.",
       'Log onto Instagram and follow any chick lol',
       "Still passing through that storm. Been 3 years. I used to want to call her, and then I'd Google her mugshot. Fuck dat.",
       'From what I read, he was late for her birthday party, and she shat, and put it in the bed. I had a hard time believing it, until I heard their therapy sessions.',
       'If you\'re being abused, whatever gender you are, reach out to me, or someone you trust. Do not let yourself be gaslighted into abuse. I\'ll call you or get you a number to call, if you feel like your "partner" is treating you wrong. Real shit. DM me.',
       "It's really fucking sad, and this post has blown up, I'd rather just go on to bed.. Fuck. I'm staying awake to defend Johnny of the insanity, but I'm going insane myself doing so. Cheers. Thank you.",
       'Welp, good morning, holy fuck this shit blew up lol',
       "Modern women mentality, yes. I don't hate my mother, or little sister. But yes.",
       'Wait until you hear about Jesus', 'Thank you',
       "I know. I'm a traditional guy. Thank you for reminding me of that and giving me a shred of hope.  Lol things have gotten different...",
       "Same here, I got Ya back. It ain't easy.", 'Lmao!',
       'Female own group preference', 'She chose that route. Sad.',
       'She probably is, sadly. This is the world we created.',
       "Show me where I said I wasn't an asshole. I'm honest. Women defend other women, no matter the situation. You want me to link your stupid ass the study also? I can! \n\nIn short, yes, I am being attacked by women, all of them had similar usernames. Go look! It's in front of you.  [https://www.apa.org/monitor/dec04/women](https://www.apa.org/monitor/dec04/women)",
       "No way... You could see him in Edward Scissor Hands, and just know how innocent of a dude that is.. Poor dude. Love will fuck a man's head up, for sure. It has mine.",
       "Thank you for actually providing a decent argument and showing me how I'm wrong on certain points. That's what I came here for, 7 years ago, and it's rare now. Cheers. I'll try. Everyone has their own story. I'll try to better my ending.",
       "You're right. Thanks for being cool about it",
       "I can rightfully nod to that. I'm dancing at the moment lol sorry",
       "What I want to do, is blame him for not walking away, but ladies and men both know, when you got that TRUE LOVE for someone, (or so you think) it's like a fucking drug, and you aren't rational. That's why I give some people a little leeway when it comes to relationships, because love is the strongest drug in the fucking world, and people play with it like it's candy cigarettes",
       'Same, I disappeared from FB 3 years ago.. it sucks to miss out on shit, but.. I need my mental health lol. Hit me up if you ever wanna talk, you seem chill',
       "I'm just scared knowing people upvoted you thinking you were serious.",
       "I know if I raised a baby girl for 18 years and saw her ass on the internet, I'd be internally sad. The end. Agree to disagree I guess.",
       'I had to.'], dtype=object)


df_users[df_users.user_name == 'cracksniffer666']


sum(sum([df_cracksniffer666[df_cracksniffer666.text.str.contains('fuck')].created_at.dt.date == datetime.date(2020, 2, 10)]).values)

13


suspected_dict['cracksniffer666'] = 'Created at:uknown date, used the word f*ck in 13 negative comments in FEB 10 2020'


suspected_dict

{'cracksniffer666': 'Created at:uknown date, used the word f*ck in 13 negative comments in FEB 10 2020'}


df_cracksniffer666_contributions = df_cracksniffer666.groupby(df_cracksniffer666.created_at.dt.date).size().reset_index(name='n_contributions')


fig = px.bar(df_cracksniffer666_contributions,
             x='created_at', 
             y='n_contributions', title='The number of "cracksniffer666" contributions in 2020')
fig.update_traces(marker_color='red', marker_line_width=2, opacity=1, textposition='auto') 

fig.show()


for i in df_cracksniffer666[~df_cracksniffer666.text.str.contains('fuck')].text.values:
    print(i)

Amber Heard, preparing to frame Johnny Depp, 2017
She cut off his finger, shit in his bed, and would paint bruises on herself to claim abuse from him. A piece of shit. Society is still defending her also.
Explain
That's pathetic
Username checks out. No. No we can't.
Yeah haha
The media is still praising her. Don't believe what you hear. There's still people defending her also. Listen to the therapy tapes... That's all I'll tell you
Preach.
You're a misogynist for thinking she should be treated as a man would. What world do you live in? EQUALITY.
Yeah, search anywhere for like 5 mins
Username checks out, once again. Women are more than 5 times more likely to defend and protect women, no matter the cost, what the woman did, etc. Here's an actual study for you! https://www.apa.org/monitor/dec04/women
Yeah, we have to work sex into it somehow, I forgot reddit obsessed about mating... lol jesus.. Get a hobby
google her name. Simply.
I've had 3 or 4 people "go against" what I'm saying, and they all had weird pixie/witchy/feminine usernames. It's truly sad. When do you finally admit you gender can do wrong, as we're all human? Living life on easy mode.
Prob won't happen. Which will give the green light to more women aggressors, why do they not see this ending in chaos eventually? The only reason I posted this, is because I was abused, SHE went to jail, and I still lost all my friends from her bullshit lies. SOCIETY NEEDS TO WAKE UP. To think men are so awful, when we're the exact same species as women, is hilarious. Stop giving them the pass to be awful. It's just gotten sad at this point. On another note, I couldn't imagine going to my daughter's Instagram, and seeing her ass. Wtf happened?.......
There was a literal movement about it, you clown. #metoo. Why are people hardwired to neglect abused men? Seriously ask yourself.
Comment on the wrong person, my bad
Le inkwell*!!!! 1
So you'd get beat up, have your career ruined, and be mentally tortured, for pussy? I hope you work alone, because I can't see women or men respecting you.. That's just gross
Asscrack
Still got screwed in the end.. Lost most of my friends. It's called "reputation destruction" and its common now with social media. The modern chicks I know are extremely vindictive.. :(
Say something bad about her then.
Maybe I'll meme the Elon musk thing next, since women can do no wrong on reddit. I HAVE TO ASK.... do dudes that blindly defend women on here, think they're gonna get laid, by a random, anynomous person? I've never understood that. Is it cognitive dissonance? "well, I defended m'lady, now I can sleep soundly tonight..." like I literally don't know what their main objective is.. I respect my mother, my sister, and the couple chicks I hangout wit/hook up with, and I can't see blindly defending someone if they're wrong.. My mind just can't do it. I'm glad these Neckbeards aren't attourneys/judges... Fuck..
Lies? Women can be awful, too. Either say yes, I agree, or piss off. We're aware men can be awful. The past 10 years of Twitter has proven that, but; I want you to say, "women can be awful too" and I'll respect you, and listen to what you have to say. I dare you.
Wait, Johnny Depp isn't at fault.
Fuck Chris brown too.
Let me Know when Princess Peach is the plumber instead of Mario.
Hahahahahah
Doubts. My Answer is no. Probably get another movie deal knowing Hollywood.
You're wrong dude! Not everyone thinks women can be shitty! Stop projecting. Women defend women 5x more than they would defend a man for the same thing.
Classic shaming, I'm fragile, but you're the one who feels the need to comment to a stranger and tell him who, and what he is..lol. Okay
Damn those 20k upvotes and my weird agenda! Blasted!
True
Yeah because this has everything to do with a crazy man. Fuck off.
A worm. I've fell victim to beautiful women before, and it's literally the same thing as a venus fly trap. Just no. Women are beautiful because of biology. If they weren't, we wouldn't be here. But some people try to manipulate others with that advantage. Not cool.
Deal. Lol
It's sad that healthy, lovely, young women and men are getting shown this shit. It truly upsets me, and I'm scared to have children at this point. If I have a son, I have to worry, if I have a daughter, I have to worry twice as much. Just doesn't seem worth it, wish we could hit the 90s one more time, lol
Lol. Is the chocolate chip cookie a recipe or an invention?
They're video games... Lol. Idk what you want anymore. You broke up with me 3 years ago and now try to comment here...
Hahahaha gotcha bitch!
Tell me why, and I might
You need mental help. Youve been indoctrinated, person.. Please explain how I've objectifed anyone, without sounding like and idiot, and/or deleting your comments. Go.
Stop saying stuff like that man
It's reality.. Lemons haven't evolved? Wolves didn't become man's best friend? Allright, let's just leave out the most intelligent species on the planet, no evolution or adaption there. You're right. - ____-
I don't believe in canceling people. She should go to kangaroo court.
5 out of 5 today. Username checks out. I have nothing to say to your superficial ass, lmao
Bruh, it's fake history porn. The subreddit. It's a joke, playing off of something that happened... Lol damn you must be faded like ya boi
Nice.
He was late to her birthday party, I heard, and she placed the shit in the bed.
Who? I've suffered from domestic violence. Act surprised
Lol lackey... Haha. I'm sorry a group of dudes have found out it's not worth it to lose our houses, kids, etc. Boohoo, u mad?
But seriously; are you gonna cry that men have literally one space to chat? I'm assuming you're a low value boring human, rummaging through posts.. Check out femaledatingstrategy or pink pill feminism. Id bet 100 bucks I don't hear back from you after looking there. GL!
It's crazy you can have a driver's license and vote. I hope the rest of your life is easy as it is now sweetheart..
You're a weird lonely troll most likely.
Zombieland 2009
Feel free to come on my podcast and air it out
Log onto Instagram and follow any chick lol
Still passing through that storm. Been 3 years. I used to want to call her, and then I'd Google her mugshot. Fuck dat.
From what I read, he was late for her birthday party, and she shat, and put it in the bed. I had a hard time believing it, until I heard their therapy sessions.
If you're being abused, whatever gender you are, reach out to me, or someone you trust. Do not let yourself be gaslighted into abuse. I'll call you or get you a number to call, if you feel like your "partner" is treating you wrong. Real shit. DM me.
Modern women mentality, yes. I don't hate my mother, or little sister. But yes.
Wait until you hear about Jesus
Thank you
I know. I'm a traditional guy. Thank you for reminding me of that and giving me a shred of hope.  Lol things have gotten different...
Same here, I got Ya back. It ain't easy.
Lmao!
Female own group preference
She chose that route. Sad.
She probably is, sadly. This is the world we created.
Show me where I said I wasn't an asshole. I'm honest. Women defend other women, no matter the situation. You want me to link your stupid ass the study also? I can! 

In short, yes, I am being attacked by women, all of them had similar usernames. Go look! It's in front of you.  [https://www.apa.org/monitor/dec04/women](https://www.apa.org/monitor/dec04/women)
Thank you for actually providing a decent argument and showing me how I'm wrong on certain points. That's what I came here for, 7 years ago, and it's rare now. Cheers. I'll try. Everyone has their own story. I'll try to better my ending.
You're right. Thanks for being cool about it
I can rightfully nod to that. I'm dancing at the moment lol sorry
Same, I disappeared from FB 3 years ago.. it sucks to miss out on shit, but.. I need my mental health lol. Hit me up if you ever wanna talk, you seem chill
I'm just scared knowing people upvoted you thinking you were serious.
I know if I raised a baby girl for 18 years and saw her ass on the internet, I'd be internally sad. The end. Agree to disagree I guess.
I had to.
Go look at the pinned post on my profile.... Lol
Daddy wasn't there, or daddy never told them "no". Same people defending m'females, are the same people who mock "Karen", but never go into the psychological reasoning of why these women end up extremely entitled/devoid of reality.
Part of the problem. Don't have kids. Not that a reasonable woman would let you cum inside of her, but yeah.
Or, people could Google "female own group preference" and be better off accepting the truth.
Found the founder

&#x200B;

See how dumb that sounds/feels?

It's like, we're here (most of us, somewhat intelligent people) for decent discussion, not an easter egg hunt of people you don't like. When ever someone says "found the X" I just imagine a 3 year old fitting a circle block into a circular hole. YAAAYYY I DEED ITTT!

You're better than that.
lmfao 'NEXT WEEK, ON INCEL POLICE FORCE: REDDIT'


df_pacmatt27 = df.query(" author == 'pacmatt27' ")
print(df_pacmatt27.shape)
df_pacmatt27.head()

(104, 17)


df_pacmatt27.groupby(df_pacmatt27.created_at.dt.date).size().reset_index(name='n_contributions')


df_pacmatt27.text.value_counts().head(3)

Please do.                                                                                      2
Just curious how you can identify with a movement which has essentially become a hate group?    2
K, bye.                                                                                         2
Name: text, dtype: int64


df_pacmatt27[df_pacmatt27.created_at.dt.date == datetime.date(2020, 11, 7)].text.values

array(['Just curious how you can identify with a movement which has essentially become a hate group?',
       'Just curious how you can identify with a movement which has essentially become a hate group?',
       "No, they're not and it's not a strong term. Feminists permit the spread of an ideology that openly treats men as hostile entities and pushes an agenda of securing more and more power and privilege for women while removing it for men. If you identify yourself as a feminist you are suggesting that you are accepting of that agenda. You, as an individual, may be interested in equality but that is not what feminism is.",
       "I asked it of two people who proclaimed their identification with the group. If you can't tolerate questions on it and get defensive when you receive them, that's your problem.",
       'Egalitarian.',
       'Not sure how to phrase that question more simply.',
       ">Feminism is not man hating\n\nThat's an interesting point of view, considering all of the terminology and theory is set up to paint men as the enemy and women as the heroes (or victims, they seem quite confused on whether women are powerful or weak). The clue is in the name, feminism. For more examples see: patriarchy, toxic masculinity, rape culture, mansplaining/manspreading.\n\nBLM also has a very large white-hating component but whatever, this isn't about race.\n\n>To conflate feminism with man hate, or misandry, exhibits a fundamental misunderstanding of what woman have fought for.\n\nNo, it doesn't. They have fought for protections and privileges which men are denied, legal rights which men do not have, unfair treatment across a wide range of contexts and give little to no attention to male issues (when they aren't actively suppressing those issues). There is nothing equal about feminism and you're delusional if you think that's what feminism seeks.",
       "No, it still makes sense, you just don't agree.", 'Please do.',
       "I am not. I have done. Those sub-sections who are for genuine equality are complete non-entities as far as political and social change are concerned.\n\nWhat is frequently used to divide groups? Calling a spade a spade? I don't think so. If we are going to be subjected to laws and social policies, fought for by feminism, which put men at a significant disadvantage, I will ask why feminism is not interested in equality. \n\nWhy divide? What a stupid question. Feminism is literally about division and conflict between genders. I am asking why someone would subscribe to a divisive ideology instead of pursuing genuine equality.\nThe rest of what you said is totally irrelevant. I am not American, I am not interested in Mexican immigrants or job automation, the GOP or Wall Street and I am not right-wing.",
       "No, it's not, you patronising wank.\n\nI work in psychology which is female-dominated and is full of self-proclaimed feminists. I used to be a feminist and stopped because they blatantly weren't interested in equality. No feminist movements focus on male issues, they just bleat on about the same, tired, misinformed bullshit which pale in comparison to a lot of male issues.",
       'You may not consider them feminists but they constitute the power and backbone of your movement. They\'re the ones who influence legal and social change. If you say you\'re a feminist, you admit complicity with those individuals. Also, how can you be a feminist without subscribing to patriarchy theory, exactly, and all that it entails?\n\nAnd the thing is, you say they\'re not real feminists, but they are. They hold the ideals feminism has always held. At its heart, feminism is a female advocacy movement and has no interest in genuine equality, it never did. It has always operated on the assumption that men hold power and use it to oppress women. Over the years it has added "and sometimes men" but done nothing about that. It\'s a throwaway acknowledgement to appear egalitarian rather than any genuine interest.',
       "Why not start with reproductive rights? Women have access to state-provided birth control in many countries, they have the right to terminate pregnancies, give children up for adoption and face no consequences, they can commit paternity fraud with no repercussions or refuse to notify the father. Men have absolutely no such rights.\n\nUntil recently women had the right to automatically be granted custody of children. Since the change they still receive preferential treatment in custody disputes (though admittedly not a legal right anymore). Women receive preferential treatment in all legal matters, while we're on the subject. Less likely to be arrested, charged, found guilty and sentenced for comparable crimes, shorter sentences when they are.\n\nWomen in certain countries are automatically assumed to be the victim in domestic violence disputes, despite evidence clearly demonstrating that is not representative of actuality.\n\nI could go on for a while but I've got a stats project to do, so will that be sufficient for the time being?\n\nSo do I. I just disagree that feminism is a force for good in any way. I would argue that it has achieved its purpose, exceeded its purpose and now serves to advance inequalities in favour of women.",
       "I don't associate with them because many elements are hateful. I do not label myself as a men's rights activist, I'm an egalitarian. It makes perfect sense.",
       "Women have equal rights though. And they have more rights than men. Feminism is and always has been a female advocacy movement. I can see that as a necessity in past decades but I don't see why someone would identify with it now if they genuinely wanted equality. \n\nIt's becoming more and more clear that prominent feminists want women to feel weak and frightened, not powerful and strong. They want to make everything a victimisation and an oppression, to avoid becoming irrelevant. To take no responsibility and demand more benefits, to change men and do nothing... To become passive.\n\nI'm 30 so I'm not a wee lad anymore either. I grew up seeing powerful women in my favourite films and not once did they claim to be oppressed and that the world change for them. They just strapped themselves into a mech, or picked up a shotgun, and shot the world in the face. I can't see Ellen Ripley crying and claiming she's oppressed.",
       ">“Same, tired, misinformed bullshit” sounds a lot like a person making a decision on the entirety of a thing from a very small sample size. \n\nNo, it sounds like an assessment of high-profile feminist talking points from my perspective.\n\n>This one case is not indicative that women lie about abuse. The stats don’t support that women often lie about abuse.\n\nNo, false reporting statistics suggest that people lie about crimes on a regular enough basis that we need to be careful about prosecution, slander and libel.\n\n>Besides, if you’re just going to bitch that people are focused on issues that affect them and not issues that affect you, while only being focused on issues that affect you, you’re being pretty damn hypocritical.\n\nI'm not *only* focused on issues that affect me. Where the hell have you got that from?",
       ">There are still some legitimate areas where women don't have equality.\n\nWhich? I'm not saying there aren't but I am a little curious on where you feel women do not have equality. Many of the common talking points are not as straight-forward as they appear.\n\n> It's a difficult problem, how do you push for equality in those remaining areas without legitimizing the bad parts of modern feminism? \n\nI'd start by not approaching it from a feminist perspective. Their ideology is just so, a political, sociological ideology, with no legitimacy as a scientific construct. It should not be used to inform social or legal policy.",
       "> There are multiple different branches of Feminism.\n\nPlease don't patronise me. I'm more than aware of that. \n\n>The type you're probably referring to is radical feminism which is more anarchist in nature.\n\nWrong, I am referring to mainstream third wave feminism, which is the most popular form of feminism at present.\n\n>Most Feminists you'll meet in real life literally just want equity for genders\n\nWrong. Most feminists I meet in real life are hypocrites with a startling lack of awareness of male issues, an inability to react to dissent rationally and a spiteful, greedy, vengeful victim complex.\n\n>Anti-men feminists are the exception, not the rule.\n\nWrong and, even if they were, they are not the ones informing social and legal policy and lack the power to do anything meaningful.",
       '>There are plenty of feminists that aren\'t extremists.\n\nNot anymore.\n\n>I suggest we all try moving away from this "feminazi" narrative and realise we\'re all working towards the same goal.\n\nI\'d love to, if that were true.',
       "Lmfao, no it isn't, get a grip.",
       "I don't think all women are. I think most women are fairly normal, like most men. Some are arseholes and some are sound.\n\nFeminists, I'd say, are largely tossers - male or female. \n\nNice try though, now fuck off.",
       'That\'s fun. What are you doing to eradicate toxic gender norms perpetrated by women? What are you doing to eradicate toxic behaviours perpetrated by women? Could you even tell me what those are, out of curiosity? Because no feminist I\'ve ever asked has been able to.\n\nCos, and correct me if I\'m wrong here, what it *seems* like you\'re doing is actually behaving like every agent in the world is somehow a representative of the patriarchy, hellbent on oppressing women. Films, games, television, science, technology, the law, even Terry the bus driver. Not only this, it also seems like feminism suggests that women (or, more specifically, women who agree with you) don\'t actually have to do anything to change this. All they have to do is tell men to change and then the men need to do whatever you say. The only problem with that is those rules are so unclear, convoluted and irrational that it\'s literally impossible to abide by them. So men are, wittingly or no, constantly subjecting women to micro-aggressions and toxicity and women are constantly trapped in a victim role but somehow powerful lionesses. What an appealing image "I can do no wrong and others hold me back from my true potential".\n\nWhat on earth would the point of that be? Would it... Perhaps... Be to sell more books, get more funding from academic and social institutions and to remain relevant long after equality has been achieved by creating a false dichotomy of oppressed/oppressor? OMG IT WOULD.\n\nYeah, no thanks. Gender norms are actually pretty useful in certain instances. That\'s why gender dysphoria is increasing, as is the suicide and mental illness rate.',
       "I can't m8, covid-19.",
       "I can be dismissed like that if you're too cowardly to engage me, sure. It doesn't bother me because I know I'm right. And, contrary to popular belief, being right (not what you feel) is what matters.",
       'K. Make sure you leave your feminist theory at the door!',
       "You do know that in all of those countries men face similar issues, right? It's not because of sexism, it's because those countries are shitholes.",
       "Denser, now shut up and listen to your betters. \n\n>Please show me where in the world men suffer from habitual and societal genital mutilation at the hands of the other gender.\n\nCouple of things to unpack here. Generally FGM is performed by females. In those countries where FGM is practised, MGM is also practiced by equally incompetent people in equally unsanitary conditions leading to equally severe complications. So the countries I'd show you are all of them.\n\n>Please show me a society where a man is beaten to death by his community for being a rape victim. \n\nI can't do that, but in all those societies I can show you men being beaten to death for raping a woman who was actually just having extra-marital sex. She lied to protect herself and have him killed instead. Yaaaay. Again, not sexism, just a shithole.\n\nI don't have to show you shit, you haven't shown me anything.",
       "Fuck off then?\n\nI've done pretty well today actually. You try the same, you cowardly little cunt :)",
       "Ok but can you actually show me any rights men have which women don't in developed countries? Y'no, ones that aren't total shitholes. Can you give me real examples of what feminism can actually do to be of value? Not parroted rhetoric and a gross misunderstanding of human history.",
       ">Belief in or advocacy of **women's social, political, and economic rights**\n\nYeah sounds real fucking egalitarian.",
       "No, it's not my experiences, it's men's experiences.\n\nWe can, but feminism does not aim to achieve gender equity.\n\nWe can, feminists don't.",
       "You're the one who insulted me first, coward. Tuck your tail between your legs and fuck off.",
       "None of those actually show that women suffer unequally in these countries though, do they? They just show that women suffer. Whoopdeedoo, I know that. Everyone does. I didn't dispute any of the things you've said about women's suffering. What do you think you've proven?\n\nI'd also suggest that cherry picking articles which support your position is not a very hard or convincing thing to do... Which is why I'm not wasting my time doing it, lmao.",
       'You are not a source, you are an anecdote. One piece of data. The data suggests that they do.',
       ">We are less likely to be promoted because companies assume we will take more sick time to take care of children. \n\nMore maternity leave, I assume you mean. And, shouldn't you be? You work less. Should a woman who takes nine months off per year for three years get promoted over a woman who doesn't? Having children means you're out of work. That's unfortunate but what do you suggest we do? Promote people who are not the most qualified because they got knocked up? Let them ascend to a position they are unqualified for, watch them flounder and fail while the organisation struggles? Doesn't sound great for anyone involved. Life is unfair but that doesn't make it sexist.\n\n>We are judged if we say that we don't want to have kids. \n\nI'm sorry, what? So are men. People are judged for all sorts of things. This isn't an important issue at all.\n\n>We can't walk home alone at night without being afraid. \n\nNeither can men. We are much more likely to be assaulted than women are. Nobody should walk home alone at night, that is stupid.\n\n>I mean, do people ever yell at you from cars just because you are walking?\n\nYes. I've been catcalled, groped, sexually assaulted, raped and physically assaulted by strangers and those close to me. See this is the problem. Most women don't know or care about men's experiences because men don't fill their time complaining. We get shouted at, we get assaulted, we get hurt quite badly, we recover and we try to get on with our lives. Ask the men close to you if they have ever had someone beat them up, if they've ever had to go to hospital because a stranger beat the shit out of them. Bet you they all have, bet they've at least had black eyes or bleeding lips. Have you ever been hurt? I'm absolutely certain that you have. Is that because you're a woman? No, it's because people are assholes.\n\nAnd, I'm sorry, but a lot of these issues are quite insignificant compared to male genital mutilation, preferential treatment for women in all legal issues, preferential child custody for women, no reproductive rights for men. Sexual assault, sure, I empathise heavily with women on that one, it is awful... And, at the same time, I would say that male victims of sexual assault (who are far more numerous than you may think) have a much harder time seeking and getting help for it.\n\n>There are problems on both sides and you phrase it like women have somehow become super elevated in society. \n\nThey have. More women attend and graduate from higher education, a disproportionate amount of women are hired at all tiers of the workforce and younger women out-earn their male counterparts. The only thing stopping women from occupying more powerful positions is that they do not try to get them.\n\nYou may be told what to do, but you get to choose. You can choose what to do without consulting the father or notifying anyone. And many would argue that it's not your body you are making decisions about. Not me personally, I don't give a shit... But you must understand that is a complex issue, right?",
       "I can read them, they do not suggest what you are claiming.\n\nI'll wait until you wish to continue.\n\nI do, off you fuck.",
       ">So then all catholics should account for the rape of priests\n\nLol. Yes, absolutely. They are members of an organisation that has permitted and facilitated the rape of children, are you serious? Of course they should be held accountable. Were they aware? Did they do anything to stop it? If not, why not? These are absolutely questions we should be asking and they should absolutely bear some responsibility for it.\n\n> All Christians should account for white nationalists and terrorists who attack people for their beliefs. \n\nYes. Their belief structure radicalises certain, vulnerable individuals, they are responsible.\n\n>We are all a part of groups that have members which twist our beliefs in different ways. \n\nThen hold those members accountable. Police, punish and eject them where necessary. You, as a member of feminism, are responsible for your group members. If you do not stop them, you will be held responsible for their actions. If you lack the power to stop them, leave, otherwise you are complicit.\n\n>Many of us condemn them but apparently that isn't enough for you.\n\nFucking right it's not. Is one priest condemning his colleagues for raping kids enough for you? Or should they maybe get rid of the priests who rape kids? HMM. I WONDER.",
       "No, I'm talking about men's experiences. My experiences of feminism are unique and my own. Men's experiences of feminism are ill-informed social and legal policies that have diminished their rights and cultural identity, while advancing the position of women.\n\nGreat, good for you, you're blind. Next time you have a chat with them, ask them what they've actually done to help men, aside from posting shit on facebook and reddit.",
       ">  If you CAN read, but can not grasp the concept of another human being suffering for being the gender they are \n\nNo, I can grasp it. What I'm suggesting is that isn't what's happening. These are shithole countries where everyone suffers regardless of gender. And, for the record, not understanding something wouldn't make me a hypocrite, it would make me dumb.\n\n> I have never once argued with any of your claims. \n\nYou have though. Shall I quote you?\n\n> Please show me where in the world men suffer from habitual and societal genital mutilation at the hands of the other gender. Please show me a society where a man is beaten to death by his community for being a rape victim. Please show me the numbers and sources to back your claims. \n\n> Toxic masculinity is a big problem. Societal standards on men, in general, are just as harmful to men as they are women. \n\nToxic masculinity is not a problem. At least no more than toxic cuntslutfuckery. See we can both make up offensive, sexist terms which paint an entire gender as awful.\n\n> It doesn’t boil down to “shithole” countries \n\nIt does tho. Demonstrably.\n\n>  It boils down to the fact that women ARE, factually, suffering \n\nSure, no more than men and, in many places, less. So why are we only encouraged to resolve women's issues? Not just that, resolve them no matter how petty they are, no matter how far away they are, while men in our own countries face egregious inequality. Yaaaaay feminism!\n\n> what you’re failing to realize is women aren’t the ones hurting men, typically speaking. \n\nAbsolute bullshit.\n\n> The same reasons you shit on feminists = same behavior you are actively engaging in right now. \n\nIt's a good attempt at an uno reverse but it's not actually true.\n\n>I’m not going to continue to argue with someone who cannot see reason. It truly is that simple. \n\nI'd love to see that. Seems you're actually a child who has to have the last word, even when they're wrong.",
       'Ain\'t it? "I\'m done with you" - continues for two more hours, providing nothing but insults.',
       'When I see any attempts to achieve equality I will change my mind.',
       'I oscillate wildly.', 'Yeah fuck off.',
       "No, I see what is actually there.\n\nYeah, that's bullshit. When you want to discuss this like someone with integrity would, you let me know.",
       "Nah, I do. I'm just not willing to patiently sit there and let you lie through your teeth. When you want to talk, let me know, cunt.",
       'Maybe because 90% of the responses are not from the people I actually asked. They\'re people trying to "educumacate" me about something I already understand better than they do. I asked two individuals for their perspective, not you for yours. Now fuck off until you have something useful to contribute.',
       'I am. Next.', 'Try again.',
       'If you ignore the part that makes it not egalitarian, it makes it egalitarian.\n\n\\- You',
       'They really do represent the majority and those in powerful positions within the movement. Those who effect change are absolutely not interested in equality. If you call yourself a feminist you are complicit with their agenda. End of story.',
       'K, bye.',
       "No, this isn't a misogyny thing, I'm just speaking to a lot of very stupid people. I'd say that if you were male too.",
       'K.',
       ">I'm not sure if you are aware, but there are many different sub-groups under the feminism umbrella. \n\nVery aware and they all share the same ideological foundation which is fundamentally oppositional and anti-male. This can be seen in the rhetoric, terminology, foci for change and data-collection methodology.\n\nNot interested in repeating the same discussion points again, I've done it several times now.\n\nBLM has strong anti-white elements and suffer from the same issue.\n\nYou are responsible for your movement and it has strong anti-male bias. Fix it, leave or accept the criticism.",
       'Terry.',
       ">So do men on paper, in theory\n\nExcept they don't. Oops!\n\n>most feminists, myself included, think Amber deserves as much punishment as she would absolutely be getting if the genders were swapped.\n\nShame most feminists are doing fuck all about it then, isn't it?",
       'Yes, plenty. Have a look at the sidebar.',
       ">I'd call myself a femminist. Femminism means equality between sexes.\n\nNo it doesn't. Clue is in the name.",
       'I wish I could too but you keep irritating me.\n\nGot plenty. Fuck off.',
       "Just behaving like feminists do. It's irritating isn't it? When you start actually investing some effort in helping men, I'll stop comparing suffering. Since, apparently, we have to fix all the most important issues first and all of those involve women making shit up.",
       "Yeah you can claim that as much as you want. I could say a pile of shit is perfume but it isn't.",
       "They have no reproductive rights and women receive preferential treatment in courts. The sidebar has more.\n\nThat's great. You ever feel like doing anything about it or just saying it's an important issue? Cos I don't actually see any feminists doing anything about it.",
       "Yeah cos those are the things I'm referring to ;)",
       "Nah, it's not. Eat shit.", 'Point missed.',
       "So nothing? They've done nothing except claim men are responsible for men's suffering. Fuck off.\n\n> Also, in my feminists circles we hold each other accountable for toxic behaviour all the time. Like putting other women down for falling into traditional gender roles or hurting men or body shaming or whatever. \n\nSo you shame each other for not toeing the line? Sounds like brainwashing.\n\n> Also, yes society is ingrained with misogyny. \n\nNo it isn't.\n\n>Also if you're implying feminism is a marketing ploy\n\nI'm not implying it. I'm directly stating it. So take your deadass and fuck it right off.\n\n>Also gender norms are the reason men don't come forward to police when they're sexually assaulted. \n\nYeah and sometimes gender norms are helpful.\n\n>That's what feminists have been saying this whole time. If you spend you time watching Ben Shapiro owns feminist videos, you're not getting a real idea of what real feminism is.\n\nBen Shapiro is a cunt. I know what feminism is thanks.\n\n>Do your research, read bell hooks, read Kate bornstein, read roxane gray.\n\nDone it. Don't need literature recommendations from an ignorant, patronising turd, ta.\n\n>Get rid of this outdated idea of the feminazi and maybe we can talk again in a few years. Meanwhile, I'm done here bro.\n\nNope. Please stick to your words and actually fuck off.",
       "Well if progress isn't equality then it isn't really progress is it?\n\nDon't really care.",
       "I think you can do that yourself, without my help. Unless you're a simpleton.",
       "Well if the actions of the organisation don't fit the definition, I will do exactly that.",
       'Nah, just the people who are. Got nothing to add? Then fuck off.',
       'You are indeed. Now go away.',
       'Fine, disregard that one since it\'s convenient, I\'ll drop it. What about reproductive rights? Don\'t see you mentioning that one.\n\nNo, what have you actually done? You\'ve written some letters and done some volunteer work at somewhere which is both genders. What have you actually done to help men? I want some examples.\n\nI\'m doing a lot more than that, lol. I set up a group in my area for men experiencing mental health difficulties and social isolation to give them somewhere to meet new people and do interesting things. I used to work supporting homeless teens, primarily male, and helped them to learn how to look after themselves, their homes and their finances. I have run male-only therapeutic groups in my role as a psychologist and am one of very few male psychologists in my trust, which meant I helped set up a group for male psychologists following incidents of social exclusion and gender discrimination. I\'ve also done all the shit you\'ve "done" on top of that.',
       'Cringe',
       "Feminism. Yes, which is why I don't define myself as one.", 'K.',
       "Even is sadder is that I already have! Nooooo! K, I'll use it to wank while we argue.",
       'Yep. Quite a bit actually.',
       'No, every organisation that has largely negative effects is bad. Like feminism, or Russia, or child traffickers.',
       "I'd rather not, Tumblr is a pile of shit full of nobodies. And Amber Heard has lost no contracts and plans to litigate against Deep again. Again, when feminism does something instead of claiming to do things, I'll change my mind.",
       "Feminism. It's not though. They're not fake feminists, they're the ones in charge of the movement. You are complicit in their actions. Take responsibility.",
       "So what you're saying is you're a simpleton?",
       '>  Some MRAs are misogynistic, does that make the entire MRA movement bad? \n\nIf enough of them exist that it damages the movement, yes.\n\nTake responsibility, you coward.',
       "Yep, and I have enough nobodies wasting my fucking time while I'm trying to polish my pork sword right now.\n\nThere is no evidence to the contrary. She has not been removed. The blogs, they do nothing! D:",
       "It's not an ad-hominem. Refusing to take responsibility for your movement is cowardice, coward.",
       "You wish! Slap some more shit on your face and we'll see if we can work with what you've got.",
       "Never said that. There's plenty you can do, you just don't want to be alienated.",
       'K, bye.', 'Fuck off then.', "It's called being a tosser.",
       'Please do.',
       "Yes, and it means there aren't plenty. It could mean none or it could mean any amount that isn't plenty, you insufferable tit.",
       'Go for it, now stick to your words and fuck off.',
       ">The first things that come to mind are abortion\n\nWhy do you think access to abortion is a right you deserve? Many would dispute that. I wouldn't, personally, but that is a very complex issue and it's not about being a woman, it's about religious beliefs. Secondly there would be absolutely no equality in granting women the right to abortion without similar reproductive rights being granted to men. This is actually anti-equality without comparable male rights being granted also.\n\n>  access to birth control (esp. surgical methods) \n\nNot an inequality issue. Pay for it yourself like men have to.\n\n>pay equality (though granted that’s only solvable through parental leave and guarantee of return to positions after child birth because on paper women make as much as men).\n\nOk, so you already have pay equality and the vast majority of places have government mandated maternity leave which far exceeds paternity leave. Any further progress in that area would only widen the pre-existing inequality which favours women. Pay equality is an issue that has long been solved and, again, has exceeded its mandate, now favouring women in the workplace.\n\n>At this point most of the issues that women are looking for legal protections on are issues that are uniquely female.\n\nWhat a shocker!\n\nSo far you've actually given me no examples of where women do not have equality with men. Could you answer the question I asked, please?\n\n>Feminism has always been about creating more equity,\n\nNo, it was a female advocacy group.\n\n>at this point we’ve achieved most of the larger legislative issues \n\nSo why don't you turn some of that focus towards male issues where there are gaping legislative inequalities?\n\n>Only recently (what are we on now “6th wave feminism”?) has this man-hating started to emerge and that was never really the point.\n\nJust. Lol. That is total bullshit. Man-hating has been around since the inception of feminism.",
       "Why? You said you were leaving, so leave. You aren't getting the last word in, you petty coward."],
      dtype=object)


df_users[df_users.user_name == 'pacmatt27']


sum(sum([df_pacmatt27[df_pacmatt27.text.str.contains('fuck')].created_at.dt.date == datetime.date(2020, 11, 7)]).values)

12


suspected_dict['pacmatt27'] = 'Created at:2014-02-08 , used the word f*ck in 12 negative comments in NOV 7 2020'


suspected_dict

{'cracksniffer666': 'Created at:uknown date, used the word f*ck in 13 negative comments in FEB 10 2020',
 'pacmatt27': 'Created at:2014-02-08 , used the word f*ck in 12 negative comments in NOV 7 2020'}


df_pacmatt27_contributions = df_pacmatt27.groupby(df_pacmatt27.created_at.dt.date).size().reset_index(name='n_contributions')


fig = px.bar(df_pacmatt27_contributions,
             x='created_at', 
             y='n_contributions', title='The number of "pacmatt27" contributions in 2020')
fig.update_traces(marker_color='red', marker_line_width=2, opacity=1, textposition='auto') 

fig.show()


df.text.value_counts().head(100)

[deleted]                                                                                                                                                                                                                                                                                                                                                                                          3800
[removed]                                                                                                                                                                                                                                                                                                                                                                                          1534
Amber Heard                                                                                                                                                                                                                                                                                                                                                                                         958
Make sure to follow our community guidelines.\n\n**[Get user flair](https://redd.it/e0a4mn) and check out our [Instagram page](https://www.instagram.com/celebtag) for more celebrity content!**\n\n\n*I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/Celebhub) if you have any questions or concerns.*         143
Rule 9 overused. No Johny Depp or Amber Heard memes at this time\n\n*I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/memes) if you have any questions or concerns.*                                                                                                                                              105
                                                                                                                                                                                                                                                                                                                                                                                                   ... 
Fuck this bitch                                                                                                                                                                                                                                                                                                                                                                                      14
Margot                                                                                                                                                                                                                                                                                                                                                                                               14
Make sure to follow our community guidelines.\n\n**[Get user flair](https://redd.it/e0a4mn) and check out our Instagram page for more celebrity content!**\n\n**https://www.instagram.com/celebtag**\n\n\n*I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/Celebhub) if you have any questions or concerns.*      14
I did mine                                                                                                                                                                                                                                                                                                                                                                                           14
I agree                                                                                                                                                                                                                                                                                                                                                                                              13
Name: text, Length: 100, dtype: int64


df[df.text.str.lower().str.contains("fuck amber heard") ]


df_fu = df[df.text.str.lower().str.contains("fuck amber heard")]

print(df_fu.shape)

with pd.option_context('display.max_colwidth', None):
  display(df_fu.head())

(413, 17)


df_fu.subreddit.value_counts()

r/memes                   77
r/awfuleverything         32
r/videos                  22
r/iamatotalpieceofshit    22
r/dankmemes               20
                          ..
r/TrueFMK                  1
r/changemyview             1
r/fakehistoryporn          1
r/TheRightCantMeme         1
r/FuckYouAmberHeard        1
Name: subreddit, Length: 92, dtype: int64


df_fu.author.value_counts()

-banned-                82
lobofett12               7
SlimandNone              3
flightfight1             3
Sociopathic-Panda        3
                        ..
Clobbersauze             1
iamboedefeld             1
violettigerlilly1999     1
Rocatex                  1
Good-Bumblebee3642       1
Name: author, Length: 310, dtype: int64


df_fu.submission_comment.value_counts()

comment       274
submission    139
Name: submission_comment, dtype: int64


fu_list = df_fu.author.value_counts().index.to_list()
fu_list = fu_list[1:]


df_users[df_users['user_name'].isin(fu_list)]


df_fu_contributions = df_fu.groupby(df_fu.created_at.dt.date).size().reset_index(name='n_contributions')


fig = px.bar(df_fu_contributions,
             x='created_at', 
             y='n_contributions', title='The number of "F*ck Amber Heard" contributions in 2021')
# , marker_line_color='#5296dd'

fig.show()


text = "amber heard bad"

df_bad = df[df.text.str.lower().str.contains(text)]

print(df_bad.shape)

with pd.option_context('display.max_colwidth', None):
  display(df_bad.head())

(103, 17)


df_bad.author.value_counts()

-banned-                35
lobofett12               2
Jozilla12                2
Apple20674               2
Shaved_Bears             2
                        ..
madcodez                 1
papryustheskeleton       1
InformalRemove7          1
IslewardMan              1
chuck_is_dead_vay_aq     1
Name: author, Length: 63, dtype: int64


bad_list = df_bad.author.value_counts().index.to_list()
bad_list = bad_list[1:]


df_bad.subreddit.value_counts()

r/memes                    51
r/dankmemes                15
r/redditmoment              7
r/circlejerk                5
r/teenagers                 2
r/CaptainSparrowmemes       2
r/Amber_Heard               2
r/MensRights                2
r/unfunnyredditposts        1
r/FreeKarma4You             1
r/wholesomememes            1
r/ComedyHitmen              1
r/redditshutthefuckup       1
r/MetaRunner                1
r/PewdiepieSubmissions      1
r/moviescirclejerk          1
u/AndrewTheMandrew13        1
r/MemeTemplatesOfficial     1
r/me_irl                    1
r/AntiHateCommunities       1
r/agedlikemilk              1
r/FragileMaleRedditor       1
r/meme                      1
r/copypasta                 1
r/askteenboys               1
Name: subreddit, dtype: int64


df_bad.submission_comment.value_counts()

submission    91
comment       12
Name: submission_comment, dtype: int64


df_users[df_users['user_name'].isin(bad_list)]


df_bad_contributions = df_bad.groupby(df_bad.created_at.dt.date).size().reset_index(name='n_contributions')


fig = px.bar(df_bad_contributions,
             x='created_at', 
             y='n_contributions', title='The number of "Amber Heard Bad" contributions in 2021')
fig.update_traces(marker_line_color='#5296dd', marker_line_width=0.5, opacity=1, textposition='auto') 


fig.show()


text = "amber turd"

df_turd = df[df.text.str.lower().str.contains(text)]

print(df_turd.shape)

with pd.option_context('display.max_colwidth', None):
  display(df_turd.head())

(429, 17)


df_turd.submission_comment.value_counts()

comment       418
submission     11
Name: submission_comment, dtype: int64


df_turd.subreddit.value_counts()

r/memes              44
r/MensRights         29
r/celebnsfw          22
r/entertainment      20
r/pussypassdenied    19
                     ..
r/MurderedByWords     1
r/MMA                 1
r/DCEUleaks           1
r/Vent                1
r/TooAfraidToAsk      1
Name: subreddit, Length: 97, dtype: int64


df_turd.author.value_counts()

-banned-           38
SquidAndCheese     12
Nayr747             5
Jaya_shanka         4
ginozilla1985       4
                   ..
buggerthis81        1
G_A_M_E_R_R         1
SBSmyth_68          1
DumasThePharaoh     1
Kleon_da_cat        1
Name: author, Length: 338, dtype: int64


turd_list = df_turd.author.value_counts().index.to_list()
turd_list = turd_list[1:]


df_users[df_users['user_name'].isin(turd_list)]


df_turd_contributions = df_turd.groupby(df_turd.created_at.dt.date).size().reset_index(name='n_contributions')


fig = px.bar(df_turd_contributions,
             x='created_at', 
             y='n_contributions', title='The number of "Amber Turd" contributions in 2020')
fig.update_traces(marker_line_color='#5296dd', marker_line_width=0.5, opacity=1, textposition='auto') 
# , 

fig.show()


df['text_words'].value_counts().head(10);


px.histogram(df['text_words'].to_frame(), x="text_words",title='number of words in each contribution',
            nbins=200).update_traces(marker_color='#5296dd')


df['text_words'].to_frame().value_counts()

text_words
1             10206
5              4789
6              4723
4              4461
7              4458
              ...  
364               1
550               1
551               1
552               1
1708              1
Length: 604, dtype: int64


px.bar(data_frame=df['top_level'].value_counts().to_frame().reset_index(),
       x="index", y="top_level").update_layout(title='Comment or Submission (Top Level of Contrbution "Parent")',
                   xaxis_title='contribution top level (parent) category',
                   yaxis_title='number of contributions').update_traces(marker_color='#5296dd')


df['submission_text'].value_counts().head(10)


df_audio = df.query(" submission_text == 'audio_of_amber_heard_admitting_she_was_the_one' & \
                           submission_comment == 'submission' ")
print(df_audio.shape)

with pd.option_context('display.max_colwidth', None):
  display(df_audio.head())

(10, 17)


df_audio.submission_comment

11610    submission
12604    submission
12666    submission
13613    submission
13979    submission
16192    submission
20937    submission
21438    submission
21881    submission
50005    submission
Name: submission_comment, dtype: object


df_audio.subreddit

11610             r/videos
12604         r/MensRights
12666    r/TwoXChromosomes
13613           r/Feminism
13979           r/blankies
16192           r/BillBurr
20937             r/movies
21438           r/Feminism
21881         r/MensRights
50005             r/videos
Name: subreddit, dtype: object


li = list(df_audio.author.unique())
li.remove('-banned-')
df_users[df_users.user_name.isin(li)]


df_audio_comments = df.query(" submission_text == 'audio_of_amber_heard_admitting_she_was_the_one' ")
print(df_audio_comments.shape)
df_audio_comments.head(1)

(9562, 17)


df_audio_contributions = df_audio_comments.groupby(df_audio_comments.created_at.dt.date).size().reset_index(name='n_contributions')


fig = px.bar(df_audio_contributions.head(7),
             x='created_at', 
             y='n_contributions', title='The number of contributions/date on these submissions')

fig.update_layout(
    xaxis = dict(
        title='Contribution Date',
        tickmode = 'array',
        tickvals = df_audio_contributions.head(7).created_at,
    )
)

clrs = ['red' if (y > 200) else '#5296dd' for y in df_audio_contributions.n_contributions] 

fig.update_traces(marker_color=clrs, marker_line_width=1.5, opacity=1, textposition='auto')

fig.show()


df_audio_authors = df_audio_comments.groupby(df_audio_comments.author).size().reset_index(name='n_contributions')


fig = px.bar(df_audio_authors,
             x='author', 
             y='n_contributions', title='The number of contributions per author on these submissions')
fig.update_traces(marker_line_color='#5296dd', marker_line_width=0.5,opacity=1, textposition='auto') 
# , marker_line_color='#5296dd', marker_line_width=2

fig.update_yaxes(range = [0,25])

fig.show()


df_audio_authors.sort_values('n_contributions', ascending=False)


df_audio_comments[(df_audio_comments.author == 'waitingtodiesoon') |
                 (df_audio_comments.author == 'ClementineCarson')].


df_audio2 = df.query(" submission_text == 'johnny_depp_amber_heard_new_unsensored_audio' & \
                           submission_comment == 'submission' ")
print(df_audio2.shape)

with pd.option_context('display.max_colwidth', None):
  display(df_audio2.head())

(6, 17)


li = list(df_audio2.author.unique())
df_users[df_users.user_name.isin(li)]


df_audio2_comments = df.query(" submission_text == 'johnny_depp_amber_heard_new_unsensored_audio' ")
print(df_audio2_comments.shape)
df_audio2_comments.head(1)

(6218, 17)


df_audio2_contributions = df_audio2_comments.groupby(df_audio2_comments.created_at.dt.date).size().reset_index(name='n_contributions')


fig = px.bar(df_audio2_contributions.head(4),
             x='created_at', 
             y='n_contributions', title='The number of contributions/date on these submissions')

fig.update_layout(
    xaxis = dict(
        title='Contribution Date',
        tickmode = 'array',
        tickvals = df_audio2_contributions.head(4).created_at,
    )
)

clrs = ['red' if (y > 200) else '#5296dd' for y in df_audio2_contributions.n_contributions] 

fig.update_traces(marker_color=clrs, marker_line_width=1.5, opacity=1, textposition='auto')

fig.show()


df_audio2_authors = df_audio2_comments.groupby(df_audio2_comments.author).size().reset_index(name='n_contributions')


fig = px.bar(df_audio2_authors,
             x='author', 
             y='n_contributions', title='The number of contributions per author on these submissions')
fig.update_traces(marker_line_color='#5296dd', marker_line_width=0.3
                  , textposition='auto') 
# , 

fig.update_yaxes(range = [0,25])

fig.show()


df_audio2_authors.sort_values('n_contributions', ascending=False)


df_audio2_comments[df_audio2_comments.author == 'controlandr3sistanc3'].text.value_counts()

Care to quote a statement of mine in which I've excused/defended domestic abuse? lol                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                1
A lot of people also believe that she admitted to have faked wounds with make up .  Are you one of those?                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           1
Great stuff. What's your opinion on the misleading headline in this case?                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           1
See, the funny thing is that you and some other people have here is that you assume that everyone who questions the validity of a headline has a certain agenda and then you get personal, some imply that I'm defending domestic violence others think that I'm Aquaman himself or whatever. None of that matters. :-)\n\nI'm not a fan of the term "fake news", but I do believe that headlines should be accurate and that the content delivers what that headline promises. You will find several replies within this topic that are based on the assumption that Amber Heard admitted to faking bruises/wounds with make-up, as promised by the title - but it never did happen, you might want to watch the video. It may be an unpopular and uncomfortable topic to point out the shittyness of lying headlines but still, I think that truth always should be the priority and I hate political correctness. And for the extra slow people among us - demanding truth does not imply taking any sides. The personal implications that you're making here are totally hilarious, I'm hurt, I'm strange, I'm weird and everything - funny to think about it, I read the topic of a reddit title and expected to find the content to confirm that topic. It did not do that, in fact the content proved that the headline was false. Now I'm strange and weird for discovering that? lol                                                       1
Yes, you've already made very clear that you have no problem with people lying at you. I guess it just depends on who it is that's spreading the lies. lol                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          1
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   ..
Would you be willing to acknowledge that the title of the video is a complete lie?                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  1
I have no doubt that you feel that way.  \n\n\nAgain - I simply asked for you to establish the headline's premise based on the following video and you weren't able to do so. Just keeping track of the truth :-)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   1
the hard evidence is this thread, the headline and the according video, which kind of doesn't really confirm the headline. lol                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      1
You're reading an awful lot of stuff into my posts for your own convenience, it's ok I can understand that in a way. I will be the first to apologize as soon as you can tell me where in the video she admits that her wounds were fake-up. That would have been a massive oversight on my end and subsequently completely irresponsible of me to spread wrong "facts". Thanks for your patience and help with this issue in advance :-) .                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         1
You've spent 3 days with hollow replies and ad hominem attacks (to be fair, they were somewhat poor - a "you're stupid" is pretty pathetic, IMHO). I meanwhile am just pointing out that facts should be recognized - even if someone like yourself finds them inconvenient.\n\nThe topic has been that people based their posts and opinions on a fact that "Amber Heard admitted on video that she faked wounds with makeup" - and that simply never happened so those posts and opinions have no ground. Now if they'd choose other evidence to base their comments on, I'm the first to listen to them and take them serious but lies don't help here.\n\nAgain, it's telling that people like yourself don't care about being lied at as long as it suits the agenda. Insisting on truth in reporting does not mean automatic dismissal of any other evidence, facts or information. And luckily most people view it this way as well otherwise we'd be a society that's led by headlines only and I've pointed towards the dangers of that kind of thinking several posts ago.\n\nYour dull accusations of me supporting domestic abusers are meaningless as you've proven several times that you cannot be taken seriously on any level. At least you're not a complete idiot and somehow did realize on the way that I was completely correct with my comment on the lie in the headline, so now a broader accusation has to take place.    1
Name: text, Length: 80, dtype: int64


df_audio2_comments[df_audio2_comments.author == 'controlandr3sistanc3']
df_users.query(" user_name in ['controlandr3sistanc3']")


df_lost = df.query(" submission_text == 'and_he_lost_his_job_after_all_of_this_fuck_amber' & \
                           submission_comment == 'submission' ")
print(df_lost.shape)

with pd.option_context('display.max_colwidth', None):
  display(df_lost.head(1))

(5, 17)


df_lost.author.values

array(['-banned-', 'beanzzzzzzzzzss', 'koppleberg', 'Ford456fgfd',
       'Ford456fgfd'], dtype=object)


df_lost.permalink.head(10).values

array(['/r/awfuleverything/comments/hkp7lo/and_he_lost_his_job_after_all_of_this_fuck_amber/',
       '/r/RuinedMyDay/comments/hkr7ej/and_he_lost_his_job_after_all_of_this_fuck_amber/',
       '/r/AnimalTextGifs/comments/hktj24/and_he_lost_his_job_after_all_of_this_fuck_amber/',
       '/r/awfuleverything/comments/hkuqbh/and_he_lost_his_job_after_all_of_this_fuck_amber/',
       '/r/awfuleverything/comments/hkxpm9/and_he_lost_his_job_after_all_of_this_fuck_amber/'],
      dtype=object)


df_lost_comments = df.query(" submission_text == 'and_he_lost_his_job_after_all_of_this_fuck_amber' ")
print(df_lost_comments.shape)
df_lost_comments.head()

(3568, 17)


df_lost_contributions = df_lost_comments.groupby(df_lost_comments.created_at.dt.date).size().reset_index(name='n_contributions')


fig = px.bar(df_lost_contributions.head(),
             x='created_at', 
             y='n_contributions', title='The number of contributions/date on these submissions')

fig.update_layout(
    xaxis = dict(
        title='Contribution Date',
        tickmode = 'array',
        tickvals = df_lost_contributions.head().created_at,
    )
)

clrs = ['red' if (y > 200) else '#5296dd' for y in df_lost_contributions.n_contributions] 

fig.update_traces(marker_color=clrs, marker_line_width=1.5, opacity=1, textposition='auto')

fig.show()


df_lost_authors = df_lost_comments.groupby(df_lost_comments.author).size().reset_index(name='n_contributions')


fig = px.bar(df_lost_authors,
             x='author', 
             y='n_contributions', title='The number of contributions per author on these submissions')
fig.update_traces(marker_line_color='#5296dd', marker_line_width=0.3, textposition='auto') 
# , marker_line_color='#5296dd', marker_line_width=2

fig.update_yaxes(range = [0,25])

fig.show()


df.parent_id.value_counts().head()

t3_eyp2d3    1695
t3_f0q0ao    1203
t3_kdznjp     940
t3_hkp7lo     831
t3_fwf5kv     479
Name: parent_id, dtype: int64


fig = px.bar(df.parent_id.value_counts().to_frame().head(25).reset_index(), x="parent_id", y="index",
             height=500,
             title='sumbissions with most comments (Top Level Comments)').update_layout(
                   xaxis_title='Number of comments',
                   yaxis_title='subbredit').update_traces(marker_color='#5296dd')

fig.update_yaxes(autorange="reversed")


df_top5 = df_merged[df_merged.child_id.isin(df_merged.parent_id.value_counts().head().index)]

with pd.option_context('display.max_colwidth', None):
  display(df_top5)


df_merged.submission_text = df_merged.submission_text.str.replace('_', ' ')


# get a list with the top 5 submission text
top5_text = list(df_top5.text)


top5_text

['And he lost his job after all of this. Fuck Amber Heard.',
 'Audio of Amber Heard admitting she was the one who was abusive towards Johnny Depp.',
 'Amber Heard Could Face 3 Years Of Imprisonment If Found Guilty Of Faking Evidence',
 'Johnny Depp & Amber Heard: NEW Unsensored Audio - Amber tells Depp nobody will believe him, and also admit to drawing wounds on erself with makeup and taking pictures of them for proof.',
 'Amber Heard hired for $33,000 per talk in domestic abuse, despite evidence suggesting she herself is a domestic abuser.']


for i in top5_text:
    print('- ',i)

-  And he lost his job after all of this. Fuck Amber Heard.
-  Audio of Amber Heard admitting she was the one who was abusive towards Johnny Depp.
-  Amber Heard Could Face 3 Years Of Imprisonment If Found Guilty Of Faking Evidence
-  Johnny Depp & Amber Heard: NEW Unsensored Audio - Amber tells Depp nobody will believe him, and also admit to drawing wounds on erself with makeup and taking pictures of them for proof.
-  Amber Heard hired for $33,000 per talk in domestic abuse, despite evidence suggesting she herself is a domestic abuser.


def compare(str):
    for text in top5_text:
        if str in text:
            return True
        else: return False


mask = df_merged.submission_text.apply(compare)

df_top5_contributions1 = df_merged[mask]

df_top5_authors = df_top5_contributions1.groupby(df_top5_contributions1.user_name).size().reset_index(name='n_contributions')

fig = px.bar(df_top5_authors,
             x='user_name', 
             y='n_contributions', title='The number comments per author on these submissions')

fig.update_traces(marker_color='#5296dd', opacity=1, textposition='auto') 

fig.show()


df_top5_contributions1.shape

(75, 24)


df_top5_contributions2 = df_merged[df_merged.parent_id.isin(df_merged.parent_id.value_counts().head().index)]

df_top5_authors = df_top5_contributions2.groupby(df_top5_contributions2.user_name).size().reset_index(name='n_contributions')


fig = px.bar(df_top5_authors,
             x='user_name', 
             y='n_contributions', title='The number of parent comments per author on these submissions')
fig.update_traces(marker_line_color='#5296dd', marker_line_width=0.3, textposition='auto') 
# , marker_line_color='#5296dd', marker_line_width=2

fig.update_yaxes(range = [0,5])

fig.show()


df_top5_contributions2.shape

(5148, 24)


df_submissions = df[df.submission_comment == 'submission']
print(df_submissions.shape)
df_submissions.head(2)

(7883, 17)


df_submissions.author.value_counts().nlargest(n=10)

-banned-               2571
Support_Johnny_Depp     250
DerHander               218
AutoNewsAdmin           105
toutfilm                 95
AutoNewspaperAdmin       71
newsfeedmedia            62
MetiNews                 58
CelebBattleVoteBot       49
-en-                     49
Name: author, dtype: int64


df_submissions.author.value_counts().to_frame().head(10)


fig = px.bar(df_submissions.author.value_counts().to_frame().head(10).reset_index(), x="author", y="index",
             height=500,
             title='Authors with most Submissions').update_traces(marker_color='#5296dd',).update_layout(
                   xaxis_title='Number of Negative Submissions',
                   yaxis_title='Author_Name').update_traces(marker_color='#5296dd')

fig.update_yaxes(autorange="reversed")


df_submissions.author.value_counts().head()

-banned-               2571
Support_Johnny_Depp     250
DerHander               218
AutoNewsAdmin           105
toutfilm                 95
Name: author, dtype: int64


check_list = df_submissions.author.value_counts().nlargest(n=25).index.tolist()[1:]
check_list

['Support_Johnny_Depp',
 'DerHander',
 'AutoNewsAdmin',
 'toutfilm',
 'AutoNewspaperAdmin',
 'newsfeedmedia',
 'MetiNews',
 'CelebBattleVoteBot',
 '-en-',
 'internewscast',
 'cdroid7',
 'iDevice_Help',
 'TrialTheLegend',
 'TheAndredal',
 'the-speed-of-pain',
 'distinctathlete',
 'UKNewsByABot',
 'templederr',
 'Dannig178',
 'Bot-alex',
 'removalbot',
 'rodrigohernandez4477',
 'feedimo',
 'motivatornetwork']


# get a data frame with the most negative-comments users
df_check = df_users[df_users['user_name'].isin(check_list)]
print(df_check.shape)
df_check.head(2)

(24, 10)


df_check['user_name'].nunique()

24


for col in df_check.columns:
    if col not in ['user_name', 'user_created_at']:
        print('The value counts of the users with the most submissions: ' + col)
        print(df_check[col].value_counts())
        print('\n')

The value counts of the users with the most submissions: has_verified_email
True     23
False     1
Name: has_verified_email, dtype: int64


The value counts of the users with the most submissions: is_mod
True     22
False     2
Name: is_mod, dtype: int64


The value counts of the users with the most submissions: is_gold
False    15
True      9
Name: is_gold, dtype: int64


The value counts of the users with the most submissions: is_banned
False    18
True      6
Name: is_banned, dtype: int64


The value counts of the users with the most submissions: comment_karma
 0.0        3
 12647.0    1
 2.0        1
 55.0       1
 1063.0     1
 13.0       1
 2765.0     1
 40.0       1
 1370.0     1
-10.0       1
 73.0       1
 22.0       1
 26.0       1
 10.0       1
 52848.0    1
 1.0        1
Name: comment_karma, dtype: int64


The value counts of the users with the most submissions: link_karma
245787.0     1
1870964.0    1
328.0        1
8374.0       1
2.0          1
249122.0     1
681.0        1
982410.0     1
6772.0       1
2012.0       1
20936.0      1
2629.0       1
5113.0       1
125906.0     1
20315.0      1
366459.0     1
2210.0       1
15865.0      1
Name: link_karma, dtype: int64


The value counts of the users with the most submissions: banned_unverified
others        17
banned         6
unverified     1
Name: banned_unverified, dtype: int64


The value counts of the users with the most submissions: creation_year
others    10
banned     6
2019       3
2018       3
2020       2
Name: creation_year, dtype: int64


df_check.comment_karma.min(), df_check.comment_karma.max()

(-10.0, 52848.0)


df_check.comment_karma.mean(), df_check.comment_karma.median()

(3940.277777777778, 24.0)


df_check.link_karma.min(), df_check.link_karma.max()

(2.0, 1870964.0)


df_check.link_karma.mean(), df_check.link_karma.median()

(218104.72222222222, 12119.5)


df['urls'].nunique()

1086


df[df.astype(str)['urls'] != '[]'].head(2)


df['urls'].astype('str').value_counts().head()

[]                             123195
['https://www.reddit.com']        470
['https://youtu.be']              342
['https://www.youtube.com']       197
['http://chng.it']                190
Name: urls, dtype: int64


# the value counts of the # of urls
df['urls_count'].value_counts();


fig = px.histogram(df['urls_count'].to_frame(), x="urls_count",title='Count of the number of URLS in each Contribution',
            nbins=130).update_traces(marker_color='#5296dd')

fig.update_layout(
    xaxis = dict(
        tickmode = 'array',
        tickvals = df['urls_count'],
    )
)

fig.show()


px.histogram(df[~(df['urls_count'].isin([0,60,20,16]))], x="urls_count",title='Count of the number of URLS in each Contribution',
            nbins=20).update_traces(marker_color='#5296dd')


fig = px.histogram(df['submission_words'].to_frame(), x="submission_words",
                   title='number of words in submission text',
                   nbins=50).update_traces(marker_color='#5296dd')

fig.update_layout(
    xaxis = dict(
        title='Number of submission words',
        tickmode = 'linear',
    )
)


df['subreddit'].nunique()

1164


df['subreddit'] = df['subreddit'].str[:]


df.subreddit.value_counts().to_frame().head(10).reset_index()


fig = px.bar(df.subreddit.value_counts().to_frame().head(20).reset_index(), x="subreddit", y="index",
             height=500,
             title='Most used subbredits').update_traces(marker_color='#5296dd',).update_layout(
                   xaxis_title='Number of comments',
                   yaxis_title='subbredit').update_traces(marker_color='#5296dd')

fig.update_yaxes(autorange="reversed")


# note that value_counts() neglect Zeros
df_merged["days_after_creation"].value_counts()

3011.0    1277
3009.0     862
3015.0     838
3014.0     719
3013.0     708
          ... 
4505.0       1
4939.0       1
4542.0       1
4503.0       1
4539.0       1
Name: days_after_creation, Length: 4386, dtype: int64


px.histogram(df_merged, x="days_after_creation",title='days_after_creation',
            nbins=250).update_traces(marker_color='#5296dd',).update_layout(
                   xaxis_title='number of days',)


print('The number of accounts posted the same day they was created!')
df_merged[df_merged['days_after_creation'] == 0].shape[0]

The number of accounts posted the same day they was created!

360


print('The number of accounts posted the same week they was created!')
df_merged[df_merged['days_after_creation'] <= 7].shape[0]

The number of accounts posted the same week they was created!

1209


print('The number of accounts posted the same month they was created!')
df_merged[df_merged['days_after_creation'] <= 30].shape[0]

The number of accounts posted the same month they was created!

3146


df_merged[df_merged['days_after_creation'] <= 30]['user_created_at'].dt.year.value_counts()

2020    3139
2019       7
Name: user_created_at, dtype: int64


mask = (df_merged['days_after_creation'] <= 30) & (df_merged['user_created_at'].dt.year == 2020)
df_merged[mask]['user_created_at'].dt.strftime('%b').value_counts()

Jan    611
Nov    573
Oct    325
Feb    299
Mar    267
Apr    251
Dec    204
Jun    196
Jul    172
Aug    114
May     75
Sep     52
Name: user_created_at, dtype: int64


months = df_merged[df_merged['days_after_creation'] <= 30]['user_created_at'].dt.strftime('%b')
months_sorted = months.value_counts()
months_sorted

Jan    611
Nov    573
Oct    325
Feb    299
Mar    267
Apr    251
Dec    211
Jun    196
Jul    172
Aug    114
May     75
Sep     52
Name: user_created_at, dtype: int64


months_sorted.to_frame().reset_index().rename(columns={'index':'Month',
                                                      'user_created_at': 'n_contributions'})


fig = px.bar(months_sorted.to_frame().reset_index().rename(columns={'index':'Month',
                                                      'user_created_at': 'n_contributions'}),
             x='Month', y='n_contributions', text='n_contributions')

fig.update_layout(
            title={
        'text': "contributions of the accounts posted/commented <br> the same month they were created",
        'x':0.5,
        'xanchor': 'center',
        'yanchor': 'top'
        })

# fig.update_layout(
#     xaxis = dict(
#         title='Month(2021)',
#         tickmode = 'array',
#         tickvals = [1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12],
#         ticktext = ['Jan', 'Feb', 'Mar', 'Apr', 'May', 'Jun', 'Jul', 'Aug', 'Sep', 'Oct', 'Nov', 'Dec']
#         )
# )

clrs = ['red' if (y > 100) else '#5296dd' for y in months_sorted.values] 

fig.update_traces(marker_color=clrs,
                  marker_line_width=1.5, opacity=1, textposition='auto')
fig.show()


# months_sorted.plot(kind='bar', figsize=(8,8), title='contributions of the accounts posted/commented \n the same month they were created');


# THE SAME MONTH:
# check for the date these accounts posted/commented 
reddit_30 = df_merged[df_merged['days_after_creation'] <= 30]

dates_count = df_merged.groupby(reddit_30['created_at'].dt.date).size().reset_index(name='contributions')
dates_count.sort_values('contributions', ascending=False);


fig = px.bar(dates_count,
             x='created_at', 
             y='contributions', title = 'contributions of the accounts posted/commented the same month they were created')

fig.show()


# THE SAME WEEK
# check for the date these accounts posted/commented
reddit_7 = df_merged[df_merged['days_after_creation'] <= 7]

dates_count_7 = df_merged.groupby(reddit_7['created_at'].dt.date).size().reset_index(name='contributions')
dates_count_7.sort_values('contributions', ascending=False);


fig = px.bar(dates_count_7,
             x='created_at', 
             y='contributions', title = 'contributions of the accounts posted/commented the same week they were created')

fig.show()


# THE SAME DAY
# check for the date these accounts posted/commented
reddit_1 = df_merged[df_merged['days_after_creation'] <= 0]

dates_count_1 = df_merged.groupby(reddit_1['created_at'].dt.date).size().reset_index(name='contributions')
dates_count_1.sort_values('contributions', ascending=False);


fig = px.bar(dates_count_1,
             x='created_at', 
             y='contributions', title = 'contributions of the accounts posted/commented the same day they were created')

fig.show()


# get the author names that commented in a negative way the same month the account was created
# to add to the suspected list
df_merged_30 = df_merged.query("days_after_creation <= 30 & sentiment_blob == sentiment_nltk == 'Negative' ")
df_merged_30.head()


# group by creation year and count 
df_contributions = df_merged.groupby(df_merged['user_created_at'].dt.year).size().reset_index(name='n_accounts')

fig = px.bar(df_contributions,
             x='user_created_at', y='n_accounts', text='n_accounts', title='Number of User Accounts Created in each year / having contributions in 2020')
fig.update_traces(marker_color='#5296dd',
                  marker_line_width=1.5, opacity=1, textposition='auto')
fig.show()


fig = px.bar(df.groupby(df['created_at'].dt.month).size().reset_index(name='contribution_count'),
             x='created_at', y='contribution_count', text='contribution_count')

fig.update_layout(
            title={
        'text': "Estimation of the number contributions created in each month of 2020",
        'x':0.5,
        'xanchor': 'center',
        'yanchor': 'top'
        })

fig.update_layout(
    xaxis = dict(
        title='Month(2020)',
        tickmode = 'array',
        tickvals = [1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12],
        ticktext = ['Jan', 'Feb', 'Mar', 'Apr', 'May', 'Jun', 'Jul', 'Aug', 'Sep', 'Oct', 'Nov', 'Dec']
        )
)

clrs = ['red' if (y > 4000) else '#5296dd' for y in df.groupby(df['created_at'].dt.month).size()] 

fig.update_traces(marker_color=clrs,
                  marker_line_width=1.5, opacity=1, textposition='auto')
fig.show()


fig = px.bar(df.groupby(df['created_at'].dt.day).size().reset_index(name='contribution_count'),
             x='created_at', y='contribution_count', text='contribution_count')

fig.update_layout(
            title={
        'text': "Estimation of the number contributions created in each DayOfMonth in 2020",
        'x':0.5,
        'xanchor': 'center',
        'yanchor': 'top'
        })

fig.update_layout(
    xaxis = dict(
        title='Month Days(2021)',
        tickmode = 'linear',
    )
)



clrs = ['red' if (y > 1500) else '#5296dd' for y in df.groupby(df['created_at'].dt.day).size()] 

fig.update_traces(marker_color=clrs,
                  marker_line_width=1.5, opacity=1, textposition='auto')
fig.show()


week_day = df['created_at'].dt.strftime('%a')
# one can sort by any order by providing a custom index explicitely :
# https://stackoverflow.com/questions/43855474/changing-sort-in-value-counts/43855492
week_sorted = week_day.value_counts()[['Mon', 'Tue', 'Wed', 'Thu', 'Fri', 'Sat', 'Sun']]
week_sorted

Mon    15078
Tue    22109
Wed    19155
Thu    13680
Fri    14862
Sat    22322
Sun    21202
Name: created_at, dtype: int64


fig = px.bar(df.groupby(df['created_at'].dt.dayofweek).size().reset_index(name='contribution_count'),
             x='created_at', y='contribution_count', text='contribution_count')

fig.update_layout(
            title={
        'text': "Estimation of the number contributions created in each DayOfWeek (2020)",
        'x':0.5,
        'xanchor': 'center',
        'yanchor': 'top'
        })

fig.update_layout(
    xaxis = dict(
        title='DayOfWeek(2020)',
        tickmode = 'array',
        tickvals = [0, 1, 2, 3, 4, 5, 6],
        ticktext = ['Mon', 'Tue', 'Wed', 'Thu', 'Fri', 'Sat', 'Sun']
        )
)

clrs = ['red' if (y > 4000) else '#5296dd' for y in df.groupby(df['created_at'].dt.dayofweek).size()] 

fig.update_traces(marker_color=clrs,
                  marker_line_width=1.5, opacity=1, textposition='auto')
fig.show()


# check for the hour the contributions were made
df_hours = df.groupby(df['created_at'].dt.hour).size().reset_index(name='contribution_count')
# df_hours.sort_values('contribution_count', ascending=False);   


fig = px.bar(df_hours,
             x='created_at', y='contribution_count', 
             title='Number of contrbutions Comment/Submission in day hours (2020)')

fig.update_layout(
    xaxis = dict(
        title='Hours of Day',
        tickmode = 'linear',
        dtick = 1
    )
)

fig.update_traces(marker_color='#5296dd',
                  marker_line_width=1.5, opacity=1, textposition='auto').update_layout()
fig.show()


df.created_at.dt.date.value_counts().head(20)

2020-02-04    9630
2020-02-08    6540
2020-02-02    6138
2020-11-07    5852
2020-02-07    4618
2020-02-05    4473
2020-02-09    4289
2020-12-16    3444
2020-02-06    3182
2020-02-03    3177
2020-11-08    3106
2020-05-04    2780
2020-04-07    2626
2020-07-04    2174
2020-04-09    1406
2020-11-09    1315
2020-07-03    1309
2020-04-08    1291
2020-02-10    1241
2020-11-13    1235
Name: created_at, dtype: int64


trendy_dates = df.groupby(df['created_at'].dt.date).size().reset_index(name='contribution_count')

fig = px.bar(trendy_dates,
             x='created_at', y='contribution_count')

fig.update_layout(
            title={
        'text': "The number of contributions created in each date",
        'x':0.5,
        'xanchor': 'center',
        'yanchor': 'top'
        })

fig.show()


trendy_dates.sort_values('contribution_count', ascending=False)


# get the top 5 trendy dates first, then sort them by date
top_trendy_dates = trendy_dates.sort_values('contribution_count', ascending=False).head(5)
top_trendy_dates.sort_values('contribution_count', inplace=True)


top_trendy_dates


top_trendy_dates.reset_index(inplace=True)


fig = px.bar(top_trendy_dates,
             x='created_at', y='contribution_count', title='Number of contrbutions Comment/Submission in trendy dates')

fig.update_layout(
    xaxis = dict(
        title='Contribution Date',
        tickmode = 'array',
        tickvals = top_trendy_dates.created_at,
    )
)

clrs = ['red' if (y > 400) else '#5296dd' for y in top_trendy_dates.contribution_count] 

fig.update_traces(marker_color=clrs,
                  opacity=1, textposition='auto').update_layout()

# marker_line_width=1.5,

fig.show()


def peack_days(date):
    print(f'How many users contributed on the peak day ({date})')
    print(df_merged[df_merged.created_at.dt.strftime('%Y-%m-%d') == date].user_name.nunique())
    
    print('Years')
    df_merged_peak1 = df_merged[df_merged.created_at.dt.strftime('%Y-%m-%d') == date]


    # check for the year the accounts were created
    df_user_year1 = df_merged_peak1.groupby(df_merged_peak1['user_created_at'].dt.year).size().reset_index(name='contribution_count')

    fig = px.bar(df_user_year1,
                 x='user_created_at', y='contribution_count', 
                 title=f'The creation year of the accounts contributed on the peak day ({date})')

    fig.update_layout(
        xaxis = dict(
            title='Accout Creation Year',
            tickmode = 'linear',
            dtick = 1
        )
    )

    clrs = ['red' if (y > 250) else '#5296dd' for y in df_user_year1.contribution_count] 

    fig.update_traces(marker_color=clrs,
                      marker_line_width=1.5, opacity=1, textposition='auto').update_layout()
    fig.show()
    
    print('hours')
    
    df_peak_1 = df[df.created_at.dt.strftime('%Y-%m-%d') == f'{date}']

    # check for the hour the contributions were made
    df_hours = df_peak_1.groupby(df['created_at'].dt.hour).size().reset_index(name='contribution_count')
    # df_hours.sort_values('contribution_count', ascending=False);   


    fig2 = px.bar(df_hours,
                 x='created_at', y='contribution_count', 
                 title='Number of contrbutions Comment/Submission in day hours')

    fig2.update_layout(
        xaxis = dict(
            title='Hours of Day',
            tickmode = 'linear',
            dtick = 1
        )
    )

    clrs = ['red' if (y > 80) else '#5296dd' for y in df_hours.contribution_count] 

    fig2.update_traces(marker_color=clrs,
                      marker_line_width=1.5, opacity=1, textposition='auto').update_layout()
    fig2.show()


a = list(top_trendy_dates.created_at.values)
a.sort()
for date in a:
        print(date)

2020-02-02
2020-02-04
2020-02-07
2020-02-08
2020-11-07


peack_days('2020-02-02')

How many users contributed on the peak day (2020-02-02)
3145
Years

hours


peack_days('2020-02-04')

How many users contributed on the peak day (2020-02-04)
4752
Years

hours


peack_days('2020-02-02')

How many users contributed on the peak day (2020-02-02)
3145
Years

hours


peack_days('2020-02-07')

How many users contributed on the peak day (2020-02-07)
2395
Years

hours


peack_days('2020-05-19')

How many users contributed on the peak day (2020-05-19)
180
Years

hours


peack_days('2020-07-04')

How many users contributed on the peak day (2020-07-04)
1363
Years

hours


peack_days('2020-02-07')

How many users contributed on the peak day (2020-02-07)
2395
Years

hours

	created_at	n_contributions
0	2020-02-20	1
1	2020-02-26	1
2	2020-04-08	1
3	2020-04-17	1
4	2020-05-18	1
5	2020-06-30	1
6	2020-07-04	1
7	2020-07-07	4
8	2020-07-08	6
9	2020-07-09	2
10	2020-07-10	3
11	2020-07-11	1
12	2020-07-13	5
13	2020-07-14	6
14	2020-07-15	5
15	2020-07-16	6
16	2020-07-17	2
17	2020-07-19	1
18	2020-07-20	11
19	2020-07-21	9
20	2020-07-22	10
21	2020-07-23	7
22	2020-07-24	6
23	2020-07-26	2
24	2020-07-27	1
25	2020-07-28	5
26	2020-07-29	1
27	2020-10-16	1
28	2020-10-30	1
29	2020-11-02	2
30	2020-11-03	1

	child_id	permalink	text	parent_id	subreddit	author	created_at	sentiment_blob	sentiment_nltk	score	top_level	submission_comment	text_words	submission_text	submission_words	urls
26942	t1_fgow1av	/r/askteenboys/comments/ezie45/what_do_think_about_the_johnny_depp_and_amber/fgow1av/	Johnny depp good amber heard bad	t3_ezie45	r/askteenboys	MrMeme2K23	2020-02-06 11:39:21	Neutral	Neutral	2.0	submission	comment	6	what_do_think_about_the_johnny_depp_and_amber	9	[]
30314	t3_f087pw	/r/circlejerk/comments/f087pw/amber_heard_bad_men_together_strong/	Amber Heard BAD. Men together strong	NaN	r/circlejerk	-banned-	2020-02-07 09:32:39	Negative	Neutral	0.0	NaN	submission	6	amber_heard_bad_men_together_strong	6	[]
50145	t3_fiiyr2	/r/dankmemes/comments/fiiyr2/amber_heard_bad/	Amber Heard bad	NaN	r/dankmemes	lievenazerty	2020-03-14 14:13:40	Negative	Negative	28.0	NaN	submission	3	amber_heard_bad	3	[]
57690	t3_fxgvwd	/r/FreeKarma4You/comments/fxgvwd/upvote_if_johnny_depp_good_amber_heard_bad_ill/	Upvote if johnny depp good amber heard bad. Ill upvote you back.	NaN	r/FreeKarma4You	_M0b	2020-04-08 23:00:19	Negative	Neutral	35.0	NaN	submission	12	upvote_if_johnny_depp_good_amber_heard_bad_ill	9	[]
57742	t3_fxhv2t	/r/circlejerk/comments/fxhv2t/amber_heard_bad_johnny_depp_good/	Amber Heard bad. Johnny Depp good.	NaN	r/circlejerk	pomanE	2020-04-09 00:00:04	Neutral	Neutral	5.0	NaN	submission	6	amber_heard_bad_johnny_depp_good	6	[]

	author	n_contributions
8	-banned-	1218
4582	waitingtodiesoon	46
461	ClementineCarson	45
3348	gorgossia	34
1264	KindlyOlPornographer	30
...	...	...
1854	QwertyBoi321	1
1855	R-Van	1
1856	R4K1B-	1
1857	R4nd0m235689	1
2354	The_Billy_Dee	1

	child_id	permalink	text	parent_id	subreddit	author	created_at	sentiment_blob	sentiment_nltk	score	top_level	submission_comment	text_words	submission_text	submission_words	urls
33547	t3_f0q0ao	/r/videos/comments/f0q0ao/johnny_depp_amber_heard_new_unsensored_audio/	Johnny Depp & Amber Heard: NEW Unsensored Audio - Amber tells Depp nobody will believe him, and also admit to drawing wounds on erself with makeup and taking pictures of them for proof.	NaN	r/videos	Ethernetbabe	2020-02-08 10:39:34	Positive	Positive	81052.0	NaN	submission	33	johnny_depp_amber_heard_new_unsensored_audio	7	[]
35662	t3_f0tg5b	/r/trashy/comments/f0tg5b/johnny_depp_amber_heard_new_unsensored_audio/	Johnny Depp & Amber Heard: NEW Unsensored Audio - Amber tells Depp nobody will believe him, and also admit to drawing wounds on erself with makeup and taking pictures of them for proof.	NaN	r/trashy	EpixBubble	2020-02-08 16:01:14	Positive	Positive	1.0	NaN	submission	33	johnny_depp_amber_heard_new_unsensored_audio	7	[]
38274	t3_f0xgin	/r/popularpost/comments/f0xgin/johnny_depp_amber_heard_new_unsensored_audio/	Johnny Depp & Amber Heard: NEW Unsensored Audio - Amber tells Depp nobody will believe him, and also admit to drawing wounds on erself with makeup and taking pictures of them for proof.	NaN	r/popularpost	Alexexec	2020-02-08 20:46:40	Positive	Positive	2.0	NaN	submission	33	johnny_depp_amber_heard_new_unsensored_audio	7	[]
38952	t3_f0yz17	/r/JusticeForJohnnyDepp/comments/f0yz17/johnny_depp_amber_heard_new_unsensored_audio/	Johnny Depp & Amber Heard: NEW Unsensored Audio - Amber tells Depp nobody will believe him.	NaN	r/JusticeForJohnnyDepp	HWGA_Gallifrey	2020-02-08 22:34:28	Positive	Neutral	21.0	NaN	submission	16	johnny_depp_amber_heard_new_unsensored_audio	7	[]
50020	t3_fhipze	/r/videos/comments/fhipze/johnny_depp_amber_heard_new_unsensored_audio/	Johnny Depp & Amber Heard: NEW Unsensored Audio - Amber tells Depp nobody will believe him, and also admit to drawing wounds on erself with makeup and taking pictures of them for proof.	NaN	r/videos	waifulvr94	2020-03-12 16:09:31	Positive	Positive	1.0	NaN	submission	33	johnny_depp_amber_heard_new_unsensored_audio	7	[]

	author	n_contributions
5	-banned-	823
2009	controlandr3sistanc3	80
1212	PraiseSatsuki	64
2063	demonicneon	51
768	JagTror	36
...	...	...
1177	Pengroves	1
1178	Penla	1
1181	PerfectZeong	1
1182	Petdogdavid1	1
3099	zyzzogeton	1

	index	author
0	-banned-	17396
1	AutoModerator	1679
2	5th_Law_of_Robotics	298
3	CelebBattleVoteBot	282
4	Support_Johnny_Depp	256
5	DerHander	237
6	fluidmoviestar	200
7	empatheticapathetic	114
8	AutoNewsAdmin	105
9	wiklr	104

	child_id	permalink	text	parent_id	subreddit	author	created_at	sentiment_blob	sentiment_nltk	score	top_level	submission_comment	text_words	submission_text	submission_words	urls
0	t1_ffk1d8o	/r/LeftWingMaleAdvocates/comments/eu0fth/petit...	Funny how the MeToo folks aren't saying anythi...	t3_eu0fth	r/LeftWingMaleAdvocates	5th_Law_of_Robotics	2020-01-26 04:27:01	Positive	Positive	18.0	submission	comment	11	petition_to_remove_amber_heard_from_aquaman_2_due	9	[]
1	t1_ffm7uod	/r/LeftWingMaleAdvocates/comments/eu0fth/petit...	They took "listen and believe" to heart.\n\n\n...	t1_ffm2i45	r/LeftWingMaleAdvocates	5th_Law_of_Robotics	2020-01-26 14:47:18	Positive	Neutral	9.0	comment	comment	52	petition_to_remove_amber_heard_from_aquaman_2_due	9	[]
2	t1_fgahof1	/r/iamatotalpieceofshit/comments/exo718/amber_...	And after suffering all this abuse he had to a...	t3_exo718	r/iamatotalpieceofshit	5th_Law_of_Robotics	2020-02-02 13:49:50	Negative	Neutral	110.0	submission	comment	54	amber_heard_is_a_pos	5	[]
3	t3_exotbj	/r/Egalitarianism/comments/exotbj/newly_releas...	Newly released audio has professional MeToo vi...	NaN	r/Egalitarianism	5th_Law_of_Robotics	2020-02-02 14:01:18	Positive	Negative	83.0	NaN	submission	22	newly_released_audio_has_professional_metoo	6	[]
4	t1_fgajukp	/r/Egalitarianism/comments/exotbj/newly_releas...	As part of his male privilege Johnny was force...	t3_exotbj	r/Egalitarianism	5th_Law_of_Robotics	2020-02-02 14:02:18	Negative	Neutral	22.0	submission	comment	38	newly_released_audio_has_professional_metoo	6	[]

	child_id	permalink	text	parent_id	subreddit	author	created_at	sentiment_blob	sentiment_nltk	score	top_level	submission_comment	text_words	submission_text	submission_words	urls
0	t3_fubrmn	/r/entertainment/comments/fubrmn/amber_heard_h...	Amber Heard hired private investigator to dig ...	NaN	r/entertainment	Support_Johnny_Depp	2020-04-03 16:45:29	Negative	Positive	1.0	NaN	submission	54	amber_heard_hired_private_investigator_to_dig_up	8	[]
1	t3_fw29cv	/r/MensRights/comments/fw29cv/amber_heard_coul...	Amber Heard could face up to 3 years in prison...	NaN	r/MensRights	Support_Johnny_Depp	2020-04-06 16:53:07	Negative	Negative	458.0	NaN	submission	13	amber_heard_could_face_up_to_3_years_in_prison	10	[]
2	t3_fw3cz2	/r/entertainment/comments/fw3cz2/proof_amber_h...	PROOF Amber Heard S**T IN Johnny Depp's BED - ...	NaN	r/entertainment	Support_Johnny_Depp	2020-04-06 17:50:30	Positive	Neutral	1.0	NaN	submission	11	proof_amber_heard_st_in_johnny_depps_bed_and_more	10	[]
3	t3_fw3h6p	/r/MensRights/comments/fw3h6p/johnny_deppu00a0...	Johnny Depp\u00A0jokes about severed finger af...	NaN	r/MensRights	Support_Johnny_Depp	2020-04-06 17:56:25	Neutral	Negative	12.0	NaN	submission	10	johnny_deppu00a0jokes_about_severed_finger_after	6	[]
4	t3_fw3hv8	/r/entertainment/comments/fw3hv8/exclusive_wat...	EXCLUSIVE: Watch as Johnny Depp describes how ...	NaN	r/entertainment	Support_Johnny_Depp	2020-04-06 17:57:25	Neutral	Neutral	1.0	NaN	submission	28	exclusive_watch_as_johnny_depp_describes_how_his	8	[]

	child_id	permalink	text	parent_id	subreddit	author	created_at	sentiment_blob	sentiment_nltk	score	top_level	submission_comment	text_words	submission_text	submission_words	urls
0	t3_elfro8	/r/femcelebs/comments/elfro8/amber_heard/	Amber Heard	NaN	r/femcelebs	DerHander	2020-01-07 18:49:10	Neutral	Neutral	7.0	NaN	submission	2	amber_heard	2	[]
1	t3_emqu3a	/r/femcelebs/comments/emqu3a/amber_heard/	Amber Heard	NaN	r/femcelebs	DerHander	2020-01-10 13:21:41	Neutral	Neutral	13.0	NaN	submission	2	amber_heard	2	[]
2	t3_eq774a	/r/femcelebs/comments/eq774a/amber_heard/	Amber Heard	NaN	r/femcelebs	DerHander	2020-01-17 21:57:37	Neutral	Neutral	4.0	NaN	submission	2	amber_heard	2	[]
3	t3_et7dfd	/r/femcelebs/comments/et7dfd/amber_heard/	Amber Heard	NaN	r/femcelebs	DerHander	2020-01-24 07:59:21	Neutral	Neutral	8.0	NaN	submission	2	amber_heard	2	[]
4	t3_etojm2	/r/femcelebs/comments/etojm2/amber_heard/	Amber Heard	NaN	r/femcelebs	DerHander	2020-01-25 08:59:59	Neutral	Neutral	7.0	NaN	submission	2	amber_heard	2	[]

	child_id	permalink	text	parent_id	subreddit	author	created_at	sentiment_blob	sentiment_nltk	score	top_level	submission_comment	text_words	submission_text	submission_words	urls
0	t3_gmk0zo	/r/unpopularopinion/comments/gmk0zo/if_harvey_...	If Harvey Weinstein deserved to go to prison (...	NaN	r/unpopularopinion	fluidmoviestar	2020-05-19 07:37:45	Neutral	Neutral	4266.0	NaN	submission	20	if_harvey_weinstein_deserved_to_go_to_prison_tbh	9	[]
1	t1_fr43eu3	/r/unpopularopinion/comments/gmk0zo/if_harvey_...	I’ll do some digging, I guess I haven’t pulled...	t1_fr432l7	r/unpopularopinion	fluidmoviestar	2020-05-19 07:47:45	Positive	Neutral	210.0	comment	comment	18	if_harvey_weinstein_deserved_to_go_to_prison_tbh	9	[]
2	t1_fr4458y	/r/unpopularopinion/comments/gmk0zo/if_harvey_...	Thanks for the briefing, I appreciate your help.	t1_fr43tal	r/unpopularopinion	fluidmoviestar	2020-05-19 07:59:29	Positive	Positive	36.0	comment	comment	8	if_harvey_weinstein_deserved_to_go_to_prison_tbh	9	[]
3	t1_fr44ols	/r/unpopularopinion/comments/gmk0zo/if_harvey_...	Absolutely... it’s not a short list of fraud a...	t1_fr44h9p	r/unpopularopinion	fluidmoviestar	2020-05-19 08:08:19	Positive	Negative	12.0	comment	comment	15	if_harvey_weinstein_deserved_to_go_to_prison_tbh	9	[]
4	t1_fr44wrf	/r/unpopularopinion/comments/gmk0zo/if_harvey_...	As much as I agree in principle, I’d still nee...	t1_fr44ic2	r/unpopularopinion	fluidmoviestar	2020-05-19 08:12:05	Positive	Neutral	16.0	comment	comment	69	if_harvey_weinstein_deserved_to_go_to_prison_tbh	9	[]

	child_id	permalink	text	parent_id	subreddit	author	created_at	sentiment_blob	sentiment_nltk	score	top_level	submission_comment	text_words	submission_text	submission_words	urls
0	t1_fg80m2u	/r/entertainment/comments/ewymip/amber_heard_a...	Why are you quick to believe women? They lie, ...	t1_fg70f08	r/entertainment	empatheticapathetic	2020-02-02 01:19:03	Positive	Positive	-4.0	comment	comment	10	amber_heard_admits_to_hitting_exhusband_johnny	7	[]
1	t1_fg80qo7	/r/iamatotalpieceofshit/comments/ex9ge9/amber_...	Women stick up for other women. They are a hiv...	t1_fg7zmrv	r/iamatotalpieceofshit	empatheticapathetic	2020-02-02 01:20:39	Negative	Neutral	10.0	comment	comment	19	amber_heard_admits_abusing_johnny_depp_even	7	[]
2	t1_fg81k2n	/r/iamatotalpieceofshit/comments/ex9ge9/amber_...	That's a very open ended question. I couldn't ...	t1_fg81e01	r/iamatotalpieceofshit	empatheticapathetic	2020-02-02 01:30:55	Positive	Neutral	-6.0	comment	comment	21	amber_heard_admits_abusing_johnny_depp_even	7	[]
3	t1_fg82nmf	/r/iamatotalpieceofshit/comments/ex9ge9/amber_...	I'm sexist because society sticks up for lying...	t1_fg81oe4	r/iamatotalpieceofshit	empatheticapathetic	2020-02-02 01:44:53	Neutral	Negative	8.0	comment	comment	51	amber_heard_admits_abusing_johnny_depp_even	7	[]
4	t1_fg83zom	/r/iamatotalpieceofshit/comments/ex9ge9/amber_...	>I said it’s unfortunate everyone rallied behi...	t1_fg83kdn	r/iamatotalpieceofshit	empatheticapathetic	2020-02-02 02:02:01	Negative	Neutral	7.0	comment	comment	203	amber_heard_admits_abusing_johnny_depp_even	7	[]

	child_id	permalink	text	parent_id	subreddit	author	created_at	sentiment_blob	sentiment_nltk	score	top_level	submission_comment	text_words	submission_text	submission_words	urls
0	t3_f6wct3	/r/NYPOSTauto/comments/f6wct3/fashion_petition...	[Fashion] - Petitions to fire Amber Heard as L...	NaN	r/NYPOSTauto	AutoNewsAdmin	2020-02-20 17:24:35	Neutral	Neutral	3.0	NaN	submission	12	fashion_petitions_to_fire_amber_heard_as_loréals	8	[]
1	t3_f9znse	/r/INDEPENDENTauto/comments/f9znse/arts_johnny...	[Arts] - Johnny Depp threatened to 'burn' and ...	NaN	r/INDEPENDENTauto	AutoNewsAdmin	2020-02-26 20:29:25	Neutral	Negative	1.0	NaN	submission	15	arts_johnny_depp_threatened_to_burn_and_drown	8	[]
2	t3_fxctl9	/r/GUARDIANauto/comments/fxctl9/world_amber_he...	[World] - Amber Heard to testify in Johnny Dep...	NaN	r/GUARDIANauto	AutoNewsAdmin	2020-04-08 19:18:20	Negative	Neutral	4.0	NaN	submission	13	world_amber_heard_to_testify_in_johnny_depp_case	9	[]
3	t3_g35nxe	/r/INDEPENDENTauto/comments/g35nxe/arts_johnny...	[Arts] - Johnny Depp joins Instagram and hints...	NaN	r/INDEPENDENTauto	AutoNewsAdmin	2020-04-17 16:47:05	Neutral	Neutral	1.0	NaN	submission	15	arts_johnny_depp_joins_instagram_and_hints_at	8	[]
4	t3_glz9kk	/r/GUARDIANauto/comments/glz9kk/world_johnny_d...	[World] - Johnny Depp libel claim can use Ambe...	NaN	r/GUARDIANauto	AutoNewsAdmin	2020-05-18 10:52:10	Positive	Neutral	1.0	NaN	submission	15	world_johnny_depp_libel_claim_can_use_amber_heard	9	[]

	child_id	permalink	text	parent_id	subreddit	author	created_at	sentiment_blob	sentiment_nltk	score	top_level	submission_comment	text_words	submission_text	submission_words	urls
0	t1_gbgqrp7	/r/MensRights/comments/jprmy5/petition_to_have...	Just curious how you can identify with a movem...	t1_gbgk64v	r/MensRights	pacmatt27	2020-11-07 16:29:05	Negative	Neutral	38.0	comment	comment	16	petition_to_have_amber_heard_removed_as_the	8	[]
1	t1_gbgqs10	/r/MensRights/comments/jprmy5/petition_to_have...	Just curious how you can identify with a movem...	t1_gbglcnj	r/MensRights	pacmatt27	2020-11-07 16:29:09	Negative	Neutral	-3.0	comment	comment	16	petition_to_have_amber_heard_removed_as_the	8	[]
2	t1_gbgsjai	/r/MensRights/comments/jprmy5/petition_to_have...	No, they're not and it's not a strong term. Fe...	t1_gbgryj9	r/MensRights	pacmatt27	2020-11-07 16:42:21	Positive	Neutral	23.0	comment	comment	75	petition_to_have_amber_heard_removed_as_the	8	[]
3	t1_gbgsr40	/r/MensRights/comments/jprmy5/petition_to_have...	I asked it of two people who proclaimed their ...	t1_gbgru7m	r/MensRights	pacmatt27	2020-11-07 16:43:57	Neutral	Negative	11.0	comment	comment	30	petition_to_have_amber_heard_removed_as_the	8	[]
4	t1_gbgsvil	/r/MensRights/comments/jprmy5/petition_to_have...	Egalitarian.	t1_gbgrpz2	r/MensRights	pacmatt27	2020-11-07 16:44:45	Neutral	Neutral	17.0	comment	comment	1	petition_to_have_amber_heard_removed_as_the	8	[]

	child_id	permalink	text	parent_id	subreddit	author	created_at	sentiment_blob	sentiment_nltk	score	top_level	submission_comment	text_words	submission_text	submission_words	urls	urls_count
0	t1_fg9qcsr	/r/DeFranco/comments/ex0ifz/full_audio_recordi...	Not only media outlets but youtube commentary ...	t1_fg7592b	r/DeFranco	wiklr	2020-02-02 11:12:38	Positive	Negative	4.0	comment	comment	19	full_audio_recording_of_amber_heard_and_johnny	8	[]	0
1	t1_fg9u3n6	/r/entertainment/comments/ewymip/amber_heard_a...	In his apology, he admitted to the things prin...	t1_fg7pqie	r/entertainment	wiklr	2020-02-02 11:33:38	Positive	Neutral	5.0	comment	comment	105	amber_heard_admits_to_hitting_exhusband_johnny	7	[]	0
2	t3_exna8x	/r/WeinsteinEffect/comments/exna8x/i_did_start...	I did start a physical fight: Amber Heard admi...	NaN	r/WeinsteinEffect	wiklr	2020-02-02 11:41:04	Neutral	Neutral	316.0	NaN	submission	12	i_did_start_a_physical_fight_amber_heard_admits	9	[]	0
3	t1_fga7t0d	/r/WeinsteinEffect/comments/exna8x/i_did_start...	Because in those tapes she admitted in startin...	t1_fga4ebr	r/WeinsteinEffect	wiklr	2020-02-02 12:51:21	Negative	Negative	38.0	comment	comment	108	i_did_start_a_physical_fight_amber_heard_admits	9	[]	0
4	t1_fgac52w	/r/WeinsteinEffect/comments/exna8x/i_did_start...	I dont know, I feel people are afraid of admit...	t1_fga99tq	r/WeinsteinEffect	wiklr	2020-02-02 13:18:45	Negative	Negative	20.0	comment	comment	104	i_did_start_a_physical_fight_amber_heard_admits	9	['https://www.tmz.com']	1

	user_name	has_verified_email	is_mod	is_gold	is_banned	comment_karma	link_karma	user_created_at	banned_unverified	creation_year
4432	AutoModerator	True	True	True	False	1000.0	1000.0	2012-01-05 05:24:28	others	others
5795	EtherMan	True	False	False	False	56411.0	698.0	2012-05-13 02:00:36	others	others

	child_id	permalink	text	parent_id	subreddit	author	created_at	sentiment_blob	sentiment_nltk	score	top_level	submission_comment	text_words	submission_text	submission_words	urls
0	t1_fcou3a9	/r/CelebAssPussyMouth/comments/ei1vxg/natalie_...	Fuck Anne Hathaway, watch Amber Heard, jack of...	t3_ei1vxg	r/CelebAssPussyMouth	azobran22	2020-01-01 01:19:48	Negative	Negative	2.0	submission	comment	11	natalie_portman_anne_hattaway_and_amber_heard_sex	8	[]
1	t1_fcpccc4	/r/CelebAssPussyMouth/comments/ei1vxg/natalie_...	Fuck Anne Hathaway, watch Amber, masturbate ov...	t3_ei1vxg	r/CelebAssPussyMouth	Wanchaiwarrior88	2020-01-01 05:54:33	Negative	Negative	2.0	submission	comment	8	natalie_portman_anne_hattaway_and_amber_heard_sex	8	[]
8	t1_fctyubq	/r/pickoneceleb/comments/ei1w0i/natalie_portma...	Amber sex in pool\nWatch Natalie fuck herself ...	t3_ei1w0i	r/pickoneceleb	-banned-	2020-01-02 11:58:06	Negative	Neutral	1.0	submission	comment	13	natalie_portman_anne_hattaway_and_amber_heard_sex	8	[]
31	t1_fcznaxk	/r/celebJObuds/comments/ejmzgg/anyone_for_bige...	If any of these women suddenly grew a dick, I’...	t3_ejmzgg	r/celebJObuds	Chrazi87	2020-01-04 02:29:28	Negative	Negative	3.0	submission	comment	42	anyone_for_bigenderplayfuta_fantasy_talk_with	6	[]
38	t1_fd0xess	/r/CelebrityArmpits/comments/ejhiq1/amber_hear...	Fuck it we're all a little crazy. So is Dep.	t1_fcxshw7	r/CelebrityArmpits	TheGay666	2020-01-04 08:04:27	Negative	Negative	1.0	comment	comment	10	amber_heard	2	[]

	child_id	permalink	text	parent_id	subreddit	author	created_at	sentiment_blob	sentiment_nltk	score	top_level	submission_comment	text_words	submission_text	submission_words	urls
5484	t3_exsenw	/r/offmychest/comments/exsenw/fuck_amber_heard/	Fuck Amber Heard	NaN	r/offmychest	shelbabyylynn	2020-02-02 18:10:08	Negative	Negative	116.0	NaN	submission	3	fuck_amber_heard	3	[]
20859	t3_ez0ci6	/r/dankmemes/comments/ez0ci6/fuck_amber_heard/	Fuck Amber Heard	NaN	r/dankmemes	-banned-	2020-02-05 00:33:51	Negative	Negative	1.0	NaN	submission	3	fuck_amber_heard	3	[]
38463	t3_f0xw8e	/r/POTCmemes/comments/f0xw8e/fuck_amber_heard/	Fuck Amber Heard	NaN	r/POTCmemes	SlimandNone	2020-02-08 21:17:38	Negative	Negative	1382.0	NaN	submission	3	fuck_amber_heard	3	[]
57338	t3_fxa57h	/r/iamatotalpieceofshit/comments/fxa57h/fuck_amber_heard/	Fuck Amber Heard!	NaN	r/iamatotalpieceofshit	-banned-	2020-04-08 16:57:08	Negative	Negative	1.0	NaN	submission	3	fuck_amber_heard	3	[]
57340	t3_fxa594	/r/iamatotalpieceofshit/comments/fxa594/fuck_amber_heard/	Fuck Amber Heard!	NaN	r/iamatotalpieceofshit	ManaStars	2020-04-08 16:57:11	Negative	Negative	2021.0	NaN	submission	3	fuck_amber_heard	3	[]

	child_id	permalink	text	parent_id	subreddit	author	created_at	sentiment_blob	sentiment_nltk	score	top_level	submission_comment	text_words	submission_text	submission_words	urls
76	t3_el50ij	/r/JerkOffToCelebs/comments/el50ij/amber_heard_begging_you_to_fuck_her_tight_pussy/	Amber Heard begging you to fuck her tight pussy after seeing your large throbbing dick	NaN	r/JerkOffToCelebs	tayallen808	2020-01-07 02:48:28	Negative	Negative	27.0	NaN	submission	15	amber_heard_begging_you_to_fuck_her_tight_pussy	9	[]
83	t3_el8igl	/r/JerkOffToCelebs/comments/el8igl/amber_heard_with_those_fuck_me_eyes/	Amber Heard with those “fuck me” eyes.	NaN	r/JerkOffToCelebs	-banned-	2020-01-07 07:54:18	Negative	Neutral	37.0	NaN	submission	7	amber_heard_with_those_fuck_me_eyes	7	[]
130	t3_ems2vg	/r/JerkOffToCelebs/comments/ems2vg/how_roughly_would_you_throatfuck_amber_heard/	How roughly would you throatfuck Amber Heard?	NaN	r/JerkOffToCelebs	flightfight1	2020-01-10 15:01:14	Negative	Neutral	68.0	NaN	submission	7	how_roughly_would_you_throatfuck_amber_heard	7	[]
137	t3_emyakx	/r/celebJObuds/comments/emyakx/how_roughly_would_you_facefuck_amber_heard/	How roughly would you facefuck Amber Heard?	NaN	r/celebJObuds	flightfight1	2020-01-10 22:25:04	Negative	Neutral	16.0	NaN	submission	7	how_roughly_would_you_facefuck_amber_heard	7	[]
407	t3_etyhl3	/r/JerkOffToCelebs/comments/etyhl3/amber_heard_is_my_dream_hate_fuck_whos_yours/	Amber Heard is my dream hate fuck. Who’s yours? 😏	NaN	r/JerkOffToCelebs	-GnarlyCharlie-	2020-01-25 23:26:26	Negative	Neutral	73.0	NaN	submission	10	amber_heard_is_my_dream_hate_fuck_whos_yours	9	[]

	date	n_contributions
0	2020-02-04	701
1	2020-11-07	486
2	2020-02-08	421
3	2020-02-02	396
4	2020-02-07	330
...	...	...
325	2020-03-13	1
326	2020-07-06	1
327	2020-01-19	1
328	2020-09-16	1
329	2020-10-08	1

	child_id	permalink	text	parent_id	subreddit	author	created_at	sentiment_blob	sentiment_nltk	score	top_level	submission_comment	text_words	submission_text	submission_words	urls
43684	t3_f1gjcu	/r/fakehistoryporn/comments/f1gjcu/amber_heard...	Amber Heard, preparing to frame Johnny Depp, 2017	NaN	r/fakehistoryporn	cracksniffer666	2020-02-09 22:42:34	Neutral	Neutral	36851.0	NaN	submission	8	amber_heard_preparing_to_frame_johnny_depp_2017	8	[]
43890	t1_fh6hsa8	/r/fakehistoryporn/comments/f1gjcu/amber_heard...	She cut off his finger, shit in his bed, and w...	t1_fh6gtos	r/fakehistoryporn	cracksniffer666	2020-02-10 01:45:16	Negative	Negative	742.0	comment	comment	30	amber_heard_preparing_to_frame_johnny_depp_2017	8	[]
43961	t1_fh6s1s7	/r/fakehistoryporn/comments/f1gjcu/amber_heard...	Explain	t1_fh6qdmw	r/fakehistoryporn	cracksniffer666	2020-02-10 03:18:24	Neutral	Neutral	8.0	comment	comment	1	amber_heard_preparing_to_frame_johnny_depp_2017	8	[]
43969	t1_fh6tb6r	/r/fakehistoryporn/comments/f1gjcu/amber_heard...	That's pathetic	t1_fh6pk4d	r/fakehistoryporn	cracksniffer666	2020-02-10 03:32:41	Negative	Negative	103.0	comment	comment	2	amber_heard_preparing_to_frame_johnny_depp_2017	8	[]
44020	t1_fh6wq1t	/r/fakehistoryporn/comments/f1gjcu/amber_heard...	Username checks out. No. No we can't.	t1_fh6vq0j	r/fakehistoryporn	cracksniffer666	2020-02-10 04:14:19	Neutral	Negative	31.0	comment	comment	7	amber_heard_preparing_to_frame_johnny_depp_2017	8	[]

	child_id	permalink	text	parent_id	subreddit	author	created_at	sentiment_blob	sentiment_nltk	score	top_level	submission_comment	text_words	submission_text	submission_words	urls
95925	t1_gbgqrp7	/r/MensRights/comments/jprmy5/petition_to_have...	Just curious how you can identify with a movem...	t1_gbgk64v	r/MensRights	pacmatt27	2020-11-07 16:29:05	Negative	Neutral	38.0	comment	comment	16	petition_to_have_amber_heard_removed_as_the	8	[]
95926	t1_gbgqs10	/r/MensRights/comments/jprmy5/petition_to_have...	Just curious how you can identify with a movem...	t1_gbglcnj	r/MensRights	pacmatt27	2020-11-07 16:29:09	Negative	Neutral	-3.0	comment	comment	16	petition_to_have_amber_heard_removed_as_the	8	[]
95992	t1_gbgsjai	/r/MensRights/comments/jprmy5/petition_to_have...	No, they're not and it's not a strong term. Fe...	t1_gbgryj9	r/MensRights	pacmatt27	2020-11-07 16:42:21	Positive	Neutral	23.0	comment	comment	75	petition_to_have_amber_heard_removed_as_the	8	[]
96000	t1_gbgsr40	/r/MensRights/comments/jprmy5/petition_to_have...	I asked it of two people who proclaimed their ...	t1_gbgru7m	r/MensRights	pacmatt27	2020-11-07 16:43:57	Neutral	Negative	11.0	comment	comment	30	petition_to_have_amber_heard_removed_as_the	8	[]
96002	t1_gbgsvil	/r/MensRights/comments/jprmy5/petition_to_have...	Egalitarian.	t1_gbgrpz2	r/MensRights	pacmatt27	2020-11-07 16:44:45	Neutral	Neutral	17.0	comment	comment	1	petition_to_have_amber_heard_removed_as_the	8	[]

	user_name	has_verified_email	is_mod	is_gold	is_banned	comment_karma	link_karma	user_created_at	banned_unverified	creation_year
516	Shugyosha	True	True	False	False	19270.0	781.0	2009-01-13 07:27:16	others	others
2662	FrayAdjacent	True	False	False	False	50110.0	824.0	2011-06-04 01:57:00	others	others
4546	Z0MGbies	True	False	False	False	126259.0	15435.0	2012-01-17 00:57:17	others	others
4803	BarryMacochner	True	False	False	False	95737.0	1621.0	2012-02-07 00:31:03	others	others
5099	_______walrus	True	False	False	False	39283.0	4566.0	2012-03-06 07:22:58	others	others
...	...	...	...	...	...	...	...	...	...	...
69605	pastel_knives	True	True	True	True	NaN	NaN	NaT	banned	banned
69866	gippalx	True	True	True	True	NaN	NaN	NaT	banned	banned
70064	JenxxJay	True	True	True	True	NaN	NaN	NaT	banned	banned
70068	RectumGoblin	True	True	True	True	NaN	NaN	NaT	banned	banned
70280	Yolo1235	True	True	True	True	NaN	NaN	NaT	banned	banned

	child_id	permalink	text	parent_id	subreddit	author	created_at	sentiment_blob	sentiment_nltk	score	top_level	submission_comment	text_words	submission_text	submission_words	urls
6786	t1_fgd481y	/r/MensRights/comments/exfjhc/in_light_of_the_recent_audio_tape_release_i_think/fgd481y/	It's now at 75 thousand. That's a more than fifty percent increase in just a day or so, after being stuck at less than 50 thousand for almost a year. People are really pissed off at Amber Turd. Er...i mean Amber Heard...	t3_exfjhc	r/MensRights	ThePigmanAgain	2020-02-02 21:26:31	Positive	Neutral	2.0	submission	comment	42	in_light_of_the_recent_audio_tape_release_i_think	10	[]
17041	t1_fgj9bjl	/r/videos/comments/eyp2d3/audio_of_amber_heard_admitting_she_was_the_one/fgj9bjl/	Amber Turd - Don’t believe a word.	t3_eyp2d3	r/videos	StrangelyBeige	2020-02-04 18:05:43	Neutral	Neutral	1.0	submission	comment	7	audio_of_amber_heard_admitting_she_was_the_one	9	[]
19533	t1_fgjvbt0	/r/videos/comments/eyp2d3/audio_of_amber_heard_admitting_she_was_the_one/fgjvbt0/	She has the aduacity to be a campaginer for domestic violence awareness when shes a part of the problem. Fuck you Amber Turd	t3_eyp2d3	r/videos	TeehSandMan	2020-02-04 21:35:01	Negative	Negative	3.0	submission	comment	23	audio_of_amber_heard_admitting_she_was_the_one	9	[]
21133	t1_fgkiayw	/r/videos/comments/eyp2d3/audio_of_amber_heard_admitting_she_was_the_one/fgkiayw/	Aka Amber Turd	t3_eyp2d3	r/videos	General-Explanation	2020-02-05 01:30:13	Neutral	Neutral	1.0	submission	comment	3	audio_of_amber_heard_admitting_she_was_the_one	9	[]
22834	t1_fgma3wu	/r/videos/comments/eyp2d3/audio_of_amber_heard_admitting_she_was_the_one/fgma3wu/	Probably not because they’re still delusional and think Amber Turd is the innocent widdle angel that would never hurt anyone.	t1_fgirw8w	r/videos	-banned-	2020-02-05 16:38:59	Positive	Positive	1.0	comment	comment	20	audio_of_amber_heard_admitting_she_was_the_one	9	[]

	user_name	has_verified_email	is_mod	is_gold	is_banned	comment_karma	link_karma	user_created_at	banned_unverified	creation_year
4	lordatlas	True	False	False	False	37236.0	44676.0	2006-02-16 02:15:23	others	others
87	Sabremesh	True	True	False	False	64497.0	172797.0	2007-03-24 15:11:41	others	others
95	malarie	True	False	False	False	7660.0	10507.0	2007-04-18 03:39:23	others	others
127	Marutar	True	True	False	False	50869.0	783.0	2007-06-16 19:38:58	others	others
411	jameson71	True	True	False	False	18558.0	12.0	2008-08-21 04:05:27	others	others
...	...	...	...	...	...	...	...	...	...	...
69651	Galvatron1117	True	True	True	True	NaN	NaN	NaT	banned	banned
69801	bloodthorn1990	True	True	True	True	NaN	NaN	NaT	banned	banned
69880	PlatinumPepe	True	True	True	True	NaN	NaN	NaT	banned	banned
69889	-Cyber_Renaissance	True	True	True	True	NaN	NaN	NaT	banned	banned
70137	Dondo1978	True	True	True	True	NaN	NaN	NaT	banned	banned

	child_id	permalink	text	parent_id	subreddit	author	created_at	sentiment_blob	sentiment_nltk	score	top_level	submission_comment	text_words	submission_text	submission_words	urls
11610	t3_eyp2d3	/r/videos/comments/eyp2d3/audio_of_amber_heard_admitting_she_was_the_one/	Audio of Amber Heard admitting she was the one who was abusive towards Johnny Depp.	NaN	r/videos	KindlyOlPornographer	2020-02-04 12:04:19	Neutral	Negative	98525.0	NaN	submission	15	audio_of_amber_heard_admitting_she_was_the_one	9	[]
12604	t3_eyqutf	/r/MensRights/comments/eyqutf/audio_of_amber_heard_admitting_she_was_the_one/	Audio of Amber Heard admitting she was the one who was abusive towards Johnny Depp.	NaN	r/MensRights	xool420	2020-02-04 14:31:32	Neutral	Negative	27.0	NaN	submission	15	audio_of_amber_heard_admitting_she_was_the_one	9	[]
12666	t3_eyqw0c	/r/TwoXChromosomes/comments/eyqw0c/audio_of_amber_heard_admitting_she_was_the_one/	Audio of Amber Heard admitting she was the one who was abusive towards Johnny Depp.	NaN	r/TwoXChromosomes	-banned-	2020-02-04 14:34:07	Neutral	Negative	2.0	NaN	submission	15	audio_of_amber_heard_admitting_she_was_the_one	9	[]
13613	t3_eyrh1b	/r/Feminism/comments/eyrh1b/audio_of_amber_heard_admitting_she_was_the_one/	Audio of Amber Heard admitting she was the one who was abusive towards Johnny Depp	NaN	r/Feminism	-banned-	2020-02-04 15:15:39	Neutral	Negative	1.0	NaN	submission	15	audio_of_amber_heard_admitting_she_was_the_one	9	[]
13979	t3_eyror4	/r/blankies/comments/eyror4/audio_of_amber_heard_admitting_she_was_the_one/	Audio of Amber Heard admitting she was the one who was abusive towards Johnny Depp.	NaN	r/blankies	redditchao999	2020-02-04 15:30:07	Neutral	Negative	6.0	NaN	submission	15	audio_of_amber_heard_admitting_she_was_the_one	9	[]

Case Study: Reddit Social Network Analysis Against Influence Operation¶

Table of Contents¶

Introduction¶

Exploratory Data Analysis¶

Reddit Contributions (Comments / Submissions)¶

The # of submissions VS the # of comments¶

Most contributed user¶

Further Investigate The Most Commented Users In 2020 (Except Baanned).¶

AutoModerator¶

Banned accounts will be analysed in different notebook¶

5th_Law_of_Robotics¶

Support_Johnny_Depp¶

DerHander¶

fluidmoviestar¶

the contrbutions in only one subbreddit.¶

empatheticapathetic¶

AutoNewsAdmin¶

pacmatt27¶

wiklr¶

Check wether the users with the most contributions are mod, gold or having a verified email¶

Investigate the text column¶

Investigate The Most Negative key Words Used (from the wordcloud map)¶

Lets first check for the users using the word 'f*ck'¶

cracksniffer666¶

pacmatt27¶

Check for the repeated text¶

amber heard bad¶

Amber Turd¶

Check the number of text words

Reddit Comments¶

The number of parent comments on submissions¶

Reddit Submission Data¶

Investigating the Submission Text (Submissions with the most comments and replies)

audio_of_amber_heard_admitting_she_was_the_one¶

Johnny_depp_amber_heard_new_unsensored_audio¶

jand_he_lost_his_job_after_all_of_this_fuck_amber¶

Invesigating the sumbissions with most comments (Top Level Comments)

Check the top 5 submissions in 2020¶

Define a function to create the mask and check if a submission text is part of the top 5 submissions¶

Check the authors of parent comments¶

Invesigating authors with the most submissions¶

Let us first Investigate authors with the most submissions¶

Check wether the users with the most submissions are mod, gold or having a verified email¶

Submission URLS¶

Check the number of submission text words

Subredits¶

Most used Subreddits¶

Merged Users Data with Comments & Submissions Data¶

Difference in time between creating the account and posting¶

Posting Duration After Account Creation¶

THE SAME MONTH:¶

THE SAME WEEK¶

THE SAME DAY¶

Estimation of Number of User Accounts Created in each year / having contributions in 2020¶

Peaks¶

Contributions count over Months in 2020¶

Contributions count over Days of month in 2020¶

In Which DayOfWeek users created more?¶

check for the hour the contributions were made (2020)¶

Which dates has the highest contrbitions for users?¶

4 Feb 2020¶

7 Febraury 2020¶

May 19,2020¶

June 4,2020¶

7 Nov 2020¶

Conclusions¶

Investigating the Submission Text
(Submissions with the most comments and replies)

Invesigating the sumbissions with most comments
(Top Level Comments)

	user_name	has_verified_email	is_mod	is_gold	is_banned	comment_karma	link_karma	user_created_at	banned_unverified	creation_year
3767	redditchao999	True	True	False	False	32903.0	7543.0	2011-10-30 02:01:08	others	others
5918	snoogins355	True	False	False	False	238857.0	19722.0	2012-05-27 13:57:43	others	others
18703	xool420	True	False	False	False	89122.0	94801.0	2015-06-25 13:49:35	others	others
50576	KindlyOlPornographer	True	False	False	False	157950.0	92848.0	2019-07-27 01:15:02	others	2019
52089	yespineapplebacon	True	False	False	False	1821.0	21692.0	2019-09-10 20:07:38	others	2019
57013	poop4456	False	False	False	False	130.0	138.0	2020-02-04 17:44:20	unverified	2020
67607	waifulvr94	True	True	True	True	NaN	NaN	NaT	banned	banned

	child_id	permalink	text	parent_id	subreddit	author	created_at	sentiment_blob	sentiment_nltk	score	top_level	submission_comment	text_words	submission_text	submission_words	urls	urls_count
12922	t1_fgioybp	/r/videos/comments/eyp2d3/audio_of_amber_heard...	Makes me almost disappointed I saw Aquaman 9x....	t1_fgiksxi	r/videos	waitingtodiesoon	2020-02-04 14:46:05	Negative	Neutral	883.0	comment	comment	47	audio_of_amber_heard_admitting_she_was_the_one	9	[]	0
13110	t1_fgippjw	/r/videos/comments/eyp2d3/audio_of_amber_heard...	I am hoping johnny depp is vindicated from thi...	t1_fgikd5z	r/videos	waitingtodiesoon	2020-02-04 14:54:39	Positive	Positive	9.0	comment	comment	57	audio_of_amber_heard_admitting_she_was_the_one	9	[]	0
13663	t1_fgirs4p	/r/videos/comments/eyp2d3/audio_of_amber_heard...	Like that other person who took part in a grou...	t1_fgiic5w	r/videos	ClementineCarson	2020-02-04 15:17:44	Negative	Neutral	6.0	comment	comment	23	audio_of_amber_heard_admitting_she_was_the_one	9	[]	0
13710	t1_fgirx3l	/r/videos/comments/eyp2d3/audio_of_amber_heard...	I find it funny out of all the states he parto...	t1_fgimev9	r/videos	ClementineCarson	2020-02-04 15:19:14	Positive	Positive	0.0	comment	comment	22	audio_of_amber_heard_admitting_she_was_the_one	9	[]	0
13714	t1_fgirxp5	/r/videos/comments/eyp2d3/audio_of_amber_heard...	I loved that movie. Jason Momoa, Willim Dafoe,...	t1_fgiplu8	r/videos	waitingtodiesoon	2020-02-04 15:19:25	Positive	Positive	-3.0	comment	comment	114	audio_of_amber_heard_admitting_she_was_the_one	9	['https://www.carnival.com']	1
...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...
25303	t1_fgnmh6o	/r/videos/comments/eyp2d3/audio_of_amber_heard...	If a list existed during Fury Road release I w...	t1_fgj250l	r/videos	waitingtodiesoon	2020-02-06 00:14:19	Positive	Negative	1.0	comment	comment	35	audio_of_amber_heard_admitting_she_was_the_one	9	[]	0
25374	t1_fgnncte	/r/videos/comments/eyp2d3/audio_of_amber_heard...	I love movies and I believe one of the best wa...	t1_fgjk8i8	r/videos	waitingtodiesoon	2020-02-06 00:23:57	Positive	Positive	1.0	comment	comment	141	audio_of_amber_heard_admitting_she_was_the_one	9	['http://www.imaxprivatetheatre.com']	1
25385	t1_fgnnk9a	/r/videos/comments/eyp2d3/audio_of_amber_heard...	8x. 1 more after I bought the 4k blu-ray.	t1_fgiq62n	r/videos	waitingtodiesoon	2020-02-06 00:26:13	Positive	Neutral	2.0	comment	comment	9	audio_of_amber_heard_admitting_she_was_the_one	9	[]	0
25396	t1_fgnno5o	/r/videos/comments/eyp2d3/audio_of_amber_heard...	Have an open mind and immerse yourself in the ...	t1_fgjbwpq	r/videos	waitingtodiesoon	2020-02-06 00:27:26	Neutral	Positive	1.0	comment	comment	12	audio_of_amber_heard_admitting_she_was_the_one	9	[]	0
25416	t1_fgno20x	/r/videos/comments/eyp2d3/audio_of_amber_heard...	The only film I know of where he showed up lat...	t1_fgiw9q9	r/videos	waitingtodiesoon	2020-02-06 00:31:39	Negative	Negative	1.0	comment	comment	78	audio_of_amber_heard_admitting_she_was_the_one	9	[]	0

	user_name	has_verified_email	is_mod	is_gold	is_banned	comment_karma	link_karma	user_created_at	banned_unverified	creation_year
13464	Ethernetbabe	True	True	False	False	24276.0	95091.0	2014-04-05 13:36:07	others	others
39549	Alexexec	True	True	False	False	43154.0	5363.0	2018-08-27 07:43:54	others	2018
49304	HWGA_Gallifrey	False	False	False	False	74419.0	928.0	2019-06-17 00:09:27	unverified	2019
49870	EpixBubble	True	True	False	False	1196.0	13592.0	2019-07-05 12:02:43	others	2019
67607	waifulvr94	True	True	True	True	NaN	NaN	NaT	banned	banned

	child_id	permalink	text	parent_id	subreddit	author	created_at	sentiment_blob	sentiment_nltk	score	top_level	submission_comment	text_words	submission_text	submission_words	urls
72999	t3_hkp7lo	/r/awfuleverything/comments/hkp7lo/and_he_lost...	And he lost his job after all of this. Fuck Am...	NaN	r/awfuleverything	-banned-	2020-07-03 19:22:46	Negative	Negative	94875.0	NaN	submission	12	and_he_lost_his_job_after_all_of_this_fuck_amber	11	[]
73000	t1_fwu153c	/r/awfuleverything/comments/hkp7lo/and_he_lost...	Is this for real? \n\nIf so wtf, psycho bitch,...	t3_hkp7lo	r/awfuleverything	MrBreaker187	2020-07-03 19:30:01	Negative	Negative	4464.0	submission	comment	14	and_he_lost_his_job_after_all_of_this_fuck_amber	11	[]
73001	t1_fwu24gd	/r/awfuleverything/comments/hkp7lo/and_he_lost...	Belive so, but she has been taken off the set ...	t1_fwu153c	r/awfuleverything	Fleischer021	2020-07-03 19:38:55	Neutral	Neutral	1626.0	comment	comment	13	and_he_lost_his_job_after_all_of_this_fuck_amber	11	[]
73002	t1_fwu251t	/r/awfuleverything/comments/hkp7lo/and_he_lost...	This is for real. She’s a psycho. He’s amazing...	t3_hkp7lo	r/awfuleverything	squidlygreen	2020-07-03 19:39:04	Positive	Neutral	92.0	submission	comment	35	and_he_lost_his_job_after_all_of_this_fuck_amber	11	[]
73003	t1_fwu26tf	/r/awfuleverything/comments/hkp7lo/and_he_lost...	Yes, it’s for real (at least directionally, ha...	t1_fwu153c	r/awfuleverything	Monkey___Boy	2020-07-03 19:39:31	Negative	Positive	114.0	comment	comment	23	and_he_lost_his_job_after_all_of_this_fuck_amber	11	[]

	child_id	permalink	text	parent_id	subreddit	created_at	sentiment_blob	sentiment_nltk	score	top_level	...	is_mod	is_gold	is_banned	comment_karma	link_karma	user_created_at	banned_unverified	creation_year	diff	days_after_creation
10955	t3_hkp7lo	/r/awfuleverything/comments/hkp7lo/and_he_lost_his_job_after_all_of_this_fuck_amber/	And he lost his job after all of this. Fuck Amber Heard.	NaN	r/awfuleverything	2020-07-03 19:22:46	Negative	Negative	94875.0	NaN	...	False	False	False	77234.0	82.0	2011-11-06 21:08:20	others	others	3161 days 22:14:26	3161.0
36944	t3_eyp2d3	/r/videos/comments/eyp2d3/audio_of_amber_heard_admitting_she_was_the_one/	Audio of Amber Heard admitting she was the one who was abusive towards Johnny Depp.	NaN	r/videos	2020-02-04 12:04:19	Neutral	Negative	98525.0	NaN	...	False	False	False	157950.0	92848.0	2019-07-27 01:15:02	others	2019	192 days 10:49:17	192.0
55444	t3_fwf5kv	/r/entertainment/comments/fwf5kv/amber_heard_could_face_3_years_of_imprisonment_if/	Amber Heard Could Face 3 Years Of Imprisonment If Found Guilty Of Faking Evidence	NaN	r/entertainment	2020-04-07 06:00:01	Negative	Negative	38903.0	NaN	...	True	True	False	54893.0	308711.0	2018-11-17 20:34:39	unverified	2018	506 days 09:25:22	506.0
58190	t3_f0q0ao	/r/videos/comments/f0q0ao/johnny_depp_amber_heard_new_unsensored_audio/	Johnny Depp & Amber Heard: NEW Unsensored Audio - Amber tells Depp nobody will believe him, and also admit to drawing wounds on erself with makeup and taking pictures of them for proof.	NaN	r/videos	2020-02-08 10:39:34	Positive	Positive	81052.0	NaN	...	True	False	False	24276.0	95091.0	2014-04-05 13:36:07	others	others	2134 days 21:03:27	2134.0
124266	t3_kdznjp	/r/awfuleverything/comments/kdznjp/amber_heard_hired_for_33000_per_talk_in_domestic/	Amber Heard hired for $33,000 per talk in domestic abuse, despite evidence suggesting she herself is a domestic abuser.	NaN	r/awfuleverything	2020-12-16 01:48:45	Neutral	Negative	64967.0	NaN	...	False	False	False	3243.0	14068.0	2019-09-17 12:11:58	others	2019	455 days 13:36:47	455.0

	child_id	permalink	text	parent_id	subreddit	author	created_at	sentiment_blob	sentiment_nltk	score	top_level	submission_comment	text_words	submission_text	submission_words	urls	urls_count
4	t3_eimt8q	/r/ladyladyboners/comments/eimt8q/amber_heard/	Amber Heard	NaN	r/ladyladyboners	-banned-	2020-01-01 19:53:43	Neutral	Neutral	11.0	NaN	submission	2	amber_heard	2	[]	0
5	t3_eioopj	/r/celebnsfw/comments/eioopj/amber_heard/	Amber Heard	NaN	r/celebnsfw	knightfall1993	2020-01-01 22:14:03	Neutral	Neutral	202.0	NaN	submission	2	amber_heard	2	[]	0

	author
-banned-	2571
Support_Johnny_Depp	250
DerHander	218
AutoNewsAdmin	105
toutfilm	95
AutoNewspaperAdmin	71
newsfeedmedia	62
MetiNews	58
CelebBattleVoteBot	49
-en-	49

	user_name	has_verified_email	is_mod	is_gold	is_banned	comment_karma	link_karma	user_created_at	banned_unverified	creation_year
13888	Dannig178	True	True	True	False	2765.0	982410.0	2014-05-14 14:35:40	others	others
16745	TheAndredal	True	True	True	False	52848.0	1870964.0	2015-01-10 04:20:02	others	others

	child_id	permalink	text	parent_id	subreddit	author	created_at	sentiment_blob	sentiment_nltk	score	top_level	submission_comment	text_words	submission_text	submission_words	urls	urls_count
12	t1_fcxq6c4	/r/Celebhub/comments/ejhpv4/amber_heard/fcxq6c4/	Make sure to follow our community guidelines.\...	t3_ejhpv4	r/Celebhub	AutoModerator	2020-01-03 16:27:21	Positive	Positive	1.0	submission	comment	44	amber_heard	2	['https://redd.it', 'https://www.instagram.com']	2
24	t1_fczhjef	/r/JerkOffToCelebs/comments/ejpdwr/amber_heard...	**Thank you for your submission. Make sure to ...	t3_ejpdwr	r/JerkOffToCelebs	AutoModerator	2020-01-04 01:29:49	Positive	Positive	1.0	submission	comment	52	amber_heard_nipple_pokies_in_a_white_tank_top	9	['https://jerkofftocelebs.com', 'https://www.i...	3

	index	subreddit
0	r/videos	24955
1	r/entertainment	8945
2	r/MensRights	8087
3	r/pussypassdenied	6589
4	r/awfuleverything	6563
5	r/memes	5181
6	r/iamatotalpieceofshit	4757
7	r/AskReddit	2898
8	r/unpopularopinion	2741
9	r/TrueOffMyChest	2378